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

📄 sql.sql

📁 很久 宏观经济韩国锦湖国家交换机海关核发个回复光滑
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
END
GO


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

/****** 对象:  StoredProcedure [dbo].[Prisoner_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].[Prisoner_Create]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：为添加新数据
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Prisoner_Create]
@Number nvarchar(50),
@WDNumber nvarchar(50),
@Name nvarchar(50),
@Sex int,
@CardType int,
@CardNum nvarchar(50),
@CardClass int,
@State int,
@InTime char(25),
@Jail int,
@CardAddress nvarchar(150),
@Postal nvarchar(50),
@Address nvarchar(150),
@PostalCode nvarchar(50),
@Phone nvarchar(50),
@Power nvarchar(100),
@PowerTime nvarchar(max),
@Remarks nvarchar(max),
@Resume nvarchar(max),
@Characteristic nvarchar(max)
AS
begin tran
INSERT INTO [dbo].[Prisoner] ([Number],[WDNumber],[Name],[Sex],[CardType],[CardNum],[CardClass],[State],[InTime],[Jail],[CardAddress],[Postal],[Address],[PostalCode],[Phone],[Power],[PowerTime],[Remarks],[Resume],[Characteristic])
VALUES (@Number,@WDNumber,
@Name,@Sex,
@CardType,@CardNum,
@CardClass,@State,
@InTime,@Jail,
@CardAddress,@Postal,
@Address,@PostalCode,
@Phone,@Power,
@PowerTime,@Remarks,
@Resume,@Characteristic)
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO


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

/****** 对象:  StoredProcedure [dbo].[Prisoner_UpDate]    脚本日期: 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_UpDate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：更新犯人信息
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Prisoner_UpDate]
@ID int,
@Number nvarchar(50),
@WDNumber nvarchar(50),
@Name nvarchar(50),
@Sex int,
@CardType int,
@CardNum nvarchar(50),
@CardClass int,
@State int,
@InTime char(25),
@Jail int,
@CardAddress nvarchar(150),
@Postal nvarchar(50),
@Address nvarchar(150),
@PostalCode nvarchar(50),
@Phone nvarchar(50),
@Power nvarchar(100),
@PowerTime nvarchar(max),
@Remarks nvarchar(max),
@Resume nvarchar(max),
@Characteristic nvarchar(max)
AS
begin tran
UPDATE [dbo].[Prisoner]
   SET [Number] = @Number
      ,[WDNumber] = @WDNumber
      ,[Name] = @Name
      ,[Sex] = @Sex
      ,[CardType] = @CardType
      ,[CardNum] = @CardNum
      ,[CardClass] = @CardClass
      ,[State] = @State
      ,[InTime] = @InTime
      ,[Jail] = @Jail
      ,[CardAddress] = @CardAddress
      ,[Postal] = @Postal
      ,[Address] = @Address
      ,[PostalCode] = @PostalCode
      ,[Phone] = @Phone
      ,[Power] = @Power
      ,[PowerTime] = @PowerTime
      ,[Remarks] = @Remarks
      ,[Resume] = @Resume
      ,[Characteristic] = @Characteristic
 WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end
' 
END
GO


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

/****** 对象:  StoredProcedure [dbo].[Police_UpDate]    脚本日期: 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_UpDate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：更新警员信息
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Police_UpDate]
@ID int,
@Number nvarchar(50),
@Name nvarchar(50),
@Sex int,
@CardType int,
@CardNum nvarchar(50),
@CardAddress nvarchar(150),
@Postal nvarchar(50),
@Address nvarchar(50),
@PostalCode nvarchar(50),
@Phone nvarchar(50),
@CardClass int,
@InTime datetime,
@State int,
@Remarks nvarchar(max),
@Resume nvarchar(max),
@Characteristic nvarchar(max)
AS
begin tran
UPDATE [dbo].[Police]
   SET [Number] = @Number
      ,[Name] = @Name
      ,[Sex] = @Sex
      ,[CardType] = @CardType
      ,[CardNum] = @CardNum
      ,[CardAddress] = @CardAddress
      ,[Postal] = @Postal
      ,[Address] = @Address
      ,[PostalCode] = @PostalCode
      ,[Phone] = @Phone
      ,[CardClass] = @CardClass
      ,[InTime] = @InTime
      ,[State] = @State
      ,[Remarks] = @Remarks
      ,[Resume] = @Resume
      ,[Characteristic] = @Characteristic
 WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end
' 
END
GO

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

/****** 对象:  StoredProcedure [dbo].[Police_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].[Police_Create]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加警员信息
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Police_Create]
@Number nvarchar(50),
@Name nvarchar(50),
@Sex int,
@CardType int,
@CardNum nvarchar(50),
@CardAddress nvarchar(150),
@Postal nvarchar(50),
@Address nvarchar(50),
@PostalCode nvarchar(50),
@Phone nvarchar(50),
@CardClass int,
@InTime datetime,
@State int,
@Remarks nvarchar(max),
@Resume nvarchar(max),
@Characteristic nvarchar(max)
AS
begin tran
INSERT INTO [dbo].[Police] ([Number],[Name],[Sex],[CardType],[CardNum],[CardAddress],[Postal],[Address],[PostalCode],[Phone],[CardClass],[InTime],[State],[Remarks],[Resume],[Characteristic])
VALUES (@Number,@Name,@Sex,@CardType,@CardNum,@CardAddress,@Postal,@Address,@PostalCode,@Phone,@CardClass,@InTime,@State,@Remarks,@Resume,@Characteristic)
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end
' 
END
GO


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

/****** 对象:  StoredProcedure [dbo].[MapInfo_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].[MapInfo_Create]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加地图信息
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[MapInfo_Create]
@Jail int,
@Name nvarchar(50),
@Type int,
@Content nvarchar(max),
@Introduce nvarchar(max),
@Describe nvarchar(max)
AS
begin tran
INSERT INTO [dbo].[MapInfo] ([Jail],[Name],[Type],[Content],[Introduce],[Describe])
VALUES (@Jail,@Name,@Type,@Content,@Introduce,@Describe)
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

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

/****** 对象:  StoredProcedure [dbo].[MapInfo_UpDate]    脚本日期: 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].[MapInfo_UpDate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加地图信息
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[MapInfo_UpDate]
@ID int,
@Jail int,
@Name nvarchar(50),
@Type int,
@Content nvarchar(max),
@Introduce nvarchar(max),
@Describe nvarchar(max)
AS
12345

⌨️ 快捷键说明

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