newlogonprecept.sql

来自「本系统是一个报表分析查询系统」· SQL 代码 · 共 34 行

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NewLogonPrecept]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[NewLogonPrecept]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO


CREATE procedure NewLogonPrecept
 @LogonPreceptID int,
 @LogonPreceptParentID int,
 @LogonPreceptNumber nvarchar(16),
 @LogonPreceptType int,
 @LogonPreceptValue nvarchar(4000),
 @LogonPreceptDesc nvarchar(128),
 @LogonPreceptLevel int,
 @LogonPreceptDetail int,
 @LogonPreceptUseSign int,
 @LogonPreceptUserID int,
 @LogonPreceptDate nvarchar(10),
 @LogonPreceptTime nvarchar(8)
as
 insert Js_LogonPrecept(Js_LogonPreceptID,Js_LogonPreceptParentID,Js_LogonPreceptNumber,Js_LogonPreceptType,Js_LogonPreceptValue,Js_LogonPreceptDesc,Js_LogonPreceptLevel,Js_LogonPreceptDetail,Js_LogonPreceptUseSign,Js_LogonPreceptUserID,Js_LogonPreceptDate,Js_LogonPreceptTime)
 values(@LogonPreceptID,@LogonPreceptParentID,@LogonPreceptNumber,@LogonPreceptType,@LogonPreceptValue,@LogonPreceptDesc,@LogonPreceptLevel,@LogonPreceptDetail,@LogonPreceptUseSign,@LogonPreceptUserID,@LogonPreceptDate,@LogonPreceptTime)

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO