newright.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO


CREATE procedure NewRight
 @RightID int,
 @RightParentID int,
 @RightNumber nvarchar(16),
 @RightName nvarchar(512),
 @RightDesc nvarchar(512),
 @RightLevel int,
 @RightDetail int,
 @RightUseSign int,
 @RightUserID int,
 @RightDate nvarchar(10),
 @RightTime nvarchar(8)
as
 insert Js_Right(Js_RightID,Js_RightParentID,Js_RightNumber,Js_RightName,Js_RightDesc,Js_RightLevel,Js_RightDetail,Js_RightUseSign,Js_RightUserID,Js_RightDate,Js_RightTime)
 values(@RightID,@RightParentID,@RightNumber,@RightName,@RightDesc,@RightLevel,@RightDetail,@RightUseSign,@RightUserID,@RightDate,@RightTime)

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO