newusergroup.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewUserGroup
 @GroupID int,
 @ParentID int,
 @Number nvarchar(16),
 @GroupName nvarchar(128),
 @UserList nvarchar(4000),
 @Admin int,
 @RightID int,
 @Desc nvarchar(512),
 @Level int,
 @Detail int,
 @UseSign int,
 @UserID int,
 @Date nvarchar(10),
 @Time nvarchar(8)
as
 insert Js_UserGroup(Js_GroupID,Js_ParentID,Js_Number,Js_GroupName,Js_UserList,Js_Admin,Js_RightID,Js_Desc,Js_Level,Js_Detail,Js_UseSign,Js_UserID,Js_Date,Js_Time)
 values(@GroupID,@ParentID,@Number,@GroupName,@UserList,@Admin,@RightID,@Desc,@Level,@Detail,@UseSign,@UserID,@Date,@Time)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO