⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 sql.sql

📁 很久 宏观经济韩国锦湖国家交换机海关核发个回复光滑
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[OutCount] [int] NOT NULL,
	[Return] [int] NOT NULL,
	[Leave] [int] NOT NULL,
	[Never] [int] NOT NULL,
	[Other] [int] NOT NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Jail', N'COLUMN',N'Class'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Jail', @level2type=N'COLUMN',@level2name=N'Class'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Jail', N'COLUMN',N'Number'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'监区编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Jail', @level2type=N'COLUMN',@level2name=N'Number'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Jail', N'COLUMN',N'Name'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'监区名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Jail', @level2type=N'COLUMN',@level2name=N'Name'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Jail', N'COLUMN',N'Police'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'负责警员' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Jail', @level2type=N'COLUMN',@level2name=N'Police'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Jail', N'COLUMN',N'Remarks'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'监区备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Jail', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Jail', N'COLUMN',N'Jail'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Jail', @level2type=N'COLUMN',@level2name=N'Jail'
GO

/****** 对象:  Table [dbo].[PhotoInfo]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PhotoInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[PhotoInfo](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Number] [int] NOT NULL CONSTRAINT [DF_ZPXX_RYID]  DEFAULT ((0)),
	[Type] [int] NOT NULL CONSTRAINT [DF_ZPXX_RYLX]  DEFAULT ((0)),
	[Name] [nvarchar](50) NULL,
	[Content] [nvarchar](max) NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'PhotoInfo', N'COLUMN',N'Number'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PhotoInfo', @level2type=N'COLUMN',@level2name=N'Number'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'PhotoInfo', N'COLUMN',N'Type'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人员类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PhotoInfo', @level2type=N'COLUMN',@level2name=N'Type'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'PhotoInfo', N'COLUMN',N'Name'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'照片名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PhotoInfo', @level2type=N'COLUMN',@level2name=N'Name'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'PhotoInfo', N'COLUMN',N'Content'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PhotoInfo', @level2type=N'COLUMN',@level2name=N'Content'
GO
/****** 对象:  Table [dbo].[Device]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Device]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Device](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Jail] [int] NOT NULL CONSTRAINT [DF_SBXX_JQID]  DEFAULT ((0)),
	[Position] [nvarchar](50) NOT NULL CONSTRAINT [DF_SBXX_SZWZ]  DEFAULT ('0'),
	[X] [int] NOT NULL CONSTRAINT [DF_SBXX_X]  DEFAULT ((0)),
	[Y] [int] NOT NULL CONSTRAINT [DF_SBXX_Y]  DEFAULT ((0)),
	[Activate] [nvarchar](50) NOT NULL CONSTRAINT [DF_SBXX_JHQID]  DEFAULT ((0)),
	[ReceiveID] [nvarchar](50) NOT NULL CONSTRAINT [DF_SBXX_JSQID]  DEFAULT ((0)),
	[ReceiveIP] [nvarchar](50) NOT NULL CONSTRAINT [DF_SBXX_JSQIP]  DEFAULT (N'0.0.0.0')
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Device', N'COLUMN',N'Jail'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'监区ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Device', @level2type=N'COLUMN',@level2name=N'Jail'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Device', N'COLUMN',N'Position'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'X坐标' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Device', @level2type=N'COLUMN',@level2name=N'Position'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Device', N'COLUMN',N'X'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'X坐标' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Device', @level2type=N'COLUMN',@level2name=N'X'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Device', N'COLUMN',N'Y'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y坐标' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Device', @level2type=N'COLUMN',@level2name=N'Y'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Device', N'COLUMN',N'Activate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'激活器ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Device', @level2type=N'COLUMN',@level2name=N'Activate'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Device', N'COLUMN',N'ReceiveID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接收器ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Device', @level2type=N'COLUMN',@level2name=N'ReceiveID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'Device', N'COLUMN',N'ReceiveIP'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接收器IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Device', @level2type=N'COLUMN',@level2name=N'ReceiveIP'
GO
/****** 对象:  Table [dbo].[RTLS]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RTLS]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[RTLS](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Prisoner] [int] NOT NULL CONSTRAINT [DF_RTLS_FRID]  DEFAULT ((0)),
	[Time] [datetime] NOT NULL CONSTRAINT [DF_RTLS_CRSJ]  DEFAULT (getdate()),
	[Jail] [int] NOT NULL CONSTRAINT [DF_RTLS_JQID]  DEFAULT ((0)),
	[Device] [int] NOT NULL CONSTRAINT [DF_RTLS_SBID]  DEFAULT ((0))
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'RTLS', N'COLUMN',N'Prisoner'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'犯人ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RTLS', @level2type=N'COLUMN',@level2name=N'Prisoner'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'RTLS', N'COLUMN',N'Time'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出入时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RTLS', @level2type=N'COLUMN',@level2name=N'Time'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'RTLS', N'COLUMN',N'Jail'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'监区ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RTLS', @level2type=N'COLUMN',@level2name=N'Jail'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'TABLE',N'RTLS', N'COLUMN',N'Device'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RTLS', @level2type=N'COLUMN',@level2name=N'Device'
GO

/****** 对象:  Table [dbo].[Operator]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Operator]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Operator](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Police] [int] NOT NULL CONSTRAINT [DF_ADMIN_JYID]  DEFAULT ((0)),
	[UserName] [nvarchar](50) NOT NULL,
	[Password] [nvarchar](50) NOT NULL CONSTRAINT [DF_ADMIN_DLMM]  DEFAULT ('123456'),
	[Power] [nvarchar](100) NOT NULL CONSTRAINT [DF_ADMIN_SYQX]  DEFAULT ('1,0,0,0,0,0,0,0,0'),
	[Power1] [nvarchar](100) NOT NULL CONSTRAINT [DF_Operator_Power1]  DEFAULT ('1,0,0,0,0,0,0,0,0'),
	[Power2] [nvarchar](100) NOT NULL CONSTRAINT [DF_Operator_Power2]  DEFAULT ('1,0,0,0,0,0,0,0,0')
) ON [PRIMARY]
END
GO

/****** 对象:  StoredProcedure [dbo].[Police_Delete]    脚本日期: 04/14/2007 16:38:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Police_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[Police_Delete]

/****** 对象:  StoredProcedure [dbo].[Prisoner_UpDate]    脚本日期: 04/14/2007 16:38:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Prisoner_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[Prisoner_Delete]

/****** 对象:  StoredProcedure [dbo].[Operator_Delete]    脚本日期: 04/14/2007 16:38:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Operator_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[Operator_Delete]

/****** 对象:  StoredProcedure [dbo].[Operator_Create]    脚本日期: 04/14/2007 16:38:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Operator_Create]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[Operator_Create]

/****** 对象:  StoredProcedure [dbo].[Operator_UpDate]    脚本日期: 04/14/2007 16:38:13 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Operator_UpDate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[Operator_UpDate]



/****** 对象:  StoredProcedure [dbo].[Police_Delete]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Police_Delete]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加警告日至
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Police_Delete]
@ID int
AS
begin tran
DELETE FROM [dbo].[Police]
      WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

/****** 对象:  StoredProcedure [dbo].[Prisoner_Delete]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Prisoner_Delete]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加警告日至
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Prisoner_Delete]
@ID int
AS
begin tran
DELETE FROM [dbo].[Prisoner]
      WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

/****** 对象:  StoredProcedure [dbo].[Operator_Delete]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Operator_Delete]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加警告日至
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Operator_Delete]
@ID int
AS
begin tran
DELETE FROM [dbo].[Operator]
      WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

/****** 对象:  StoredProcedure [dbo].[Operator_Create]    脚本日期: 04/13/2007 15:34:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Operator_Create]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加操作员
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Operator_Create]
@Police int,
@UserName nvarchar(50),
@Password nvarchar(50),
@Power nvarchar(100),
@Power1 nvarchar(100),
@Power2 nvarchar(100)
AS
begin tran
INSERT INTO [dbo].[Operator] ([Police],[UserName],[Password],[Power],[Power1],[Power2])
VALUES (@Police,@UserName,@Password,@Power,@Power1,@Power2)
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Operator_UpDate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：更新操作员
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Operator_UpDate]
@ID int,
@Police int,
@UserName nvarchar(50),
@Password nvarchar(50),
@Power nvarchar(100),
@Power1 nvarchar(100),
@Power2 nvarchar(100)
AS
begin tran
UPDATE [dbo].[Operator]
   SET [Police] = @Police
      ,[UserName] = @UserName
      ,[Password] = @Password
      ,[Power] = @Power
      ,[Power] = @Power1
      ,[Power] = @Power2
 WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end'
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -