sql.sql

很久 宏观经济韩国锦湖国家交换机海关核发个回复光滑

begin tran
UPDATE [dbo].[MapInfo]
   SET [Jail] = @Jail
      ,[Name] = @Name
      ,[Type] = @Type
      ,[Content] = @Content
      ,[Introduce] = @Introduce
      ,[Describe] = @Describe
 WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

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

/****** 对象:  StoredProcedure [dbo].[MapInfo_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].[MapInfo_Delete]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加警告日至
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[MapInfo_Delete]
@ID int
AS
begin tran
DELETE FROM [dbo].[MapInfo]
      WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

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

/****** 对象:  StoredProcedure [dbo].[PhotoInfo_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].[PhotoInfo_UpDate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：更新照片信息
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[PhotoInfo_UpDate]
@ID int,
@Number int,
@Type int,
@Name nvarchar(50),
@Content nvarchar(max)
AS
begin tran
UPDATE [dbo].[PhotoInfo]
   SET [Number] = @Number
      ,[Type] = @Type
      ,[Name] = @Name
      ,[Content] = @Content
 WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

/****** 对象:  StoredProcedure [dbo].[PhotoInfo_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].[PhotoInfo_Delete]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加警告日至
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[PhotoInfo_Delete]
@ID int
AS
begin tran
DELETE FROM [dbo].[PhotoInfo]
      WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

/****** 对象:  StoredProcedure [dbo].[Device_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].[Device_Create]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加设备信息
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Device_Create]
@Jail int,
@Position nvarchar(50),
@X int,
@Y int,
@Activate nvarchar(50),
@ReceiveID nvarchar(50),
@ReceiveIP nvarchar(50)
AS
begin tran
INSERT INTO [UtAbmsRFID].[dbo].[Device] ([Jail],[Position],[X],[Y],[Activate],[ReceiveID],[ReceiveIP])
VALUES (@Jail,@Position,@X,@Y,@Activate,@ReceiveID,@ReceiveIP)
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

/****** 对象:  StoredProcedure [dbo].[Device_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].[Device_UpDate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：更新设备信息
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Device_UpDate]
@ID int,
@Jail int,
@Position nvarchar(50),
@X int,
@Y int,
@Activate nvarchar(50),
@ReceiveID nvarchar(50),
@ReceiveIP nvarchar(50)
AS
begin tran
UPDATE [dbo].[Device]
SET [Jail] = @Jail,
[Position] = @Position,
[X] = @X,
[Y] = @Y,
[Activate] = @Activate,
[ReceiveID] = @ReceiveID,
[ReceiveIP] = @ReceiveIP
WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

/****** 对象:  StoredProcedure [dbo].[Device_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].[Device_Delete]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加警告日至
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[Device_Delete]
@ID int
AS
begin tran
DELETE FROM [dbo].[Device]
      WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

/****** 对象:  StoredProcedure [dbo].[RTLS_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].[RTLS_UpDate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：更新RTLS记录
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[RTLS_UpDate]
@ID int,
@Prisoner int,
@Time datetime,
@Jail int,
@Device int
AS
begin tran
UPDATE [dbo].[RTLS]
   SET [Prisoner] = @Prisoner
      ,[Time] = @Time
      ,[Jail] = @Jail
      ,[Device] = @Device
 WHERE [ID] = @ID
if @@error!=0
	begin
		rollback
	end
else
	begin
		commit
	end' 
END
GO

/****** 对象:  StoredProcedure [dbo].[RTLS_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].[RTLS_Create]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'------------------------------------
--
--用途：添加RTLS记录
--时间：2007年4月10日
-------------------------------------
CREATE PROCEDURE [dbo].[RTLS_Create]
@Prisoner int,
@Time datetime,
@Jail int,
@Device int
AS
begin tran
INSERT INTO [dbo].[RTLS] ([Prisoner],[Time],[Jail],[Device])
VALUES (@Prisoner,@Time,@Jail,@Device)
if @@error!=0
	begin
		rollback
	end
else
	begin