newuser.sql

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

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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE procedure NewUser
 @UserID int,
 @UserNumber nvarchar(16),
 @UserName nvarchar(128),
 @UserPass nvarchar(64),
 @UserGroupList nvarchar(4000),
 @LogonPreceptID int,
 @RightID int,
 @Desc nvarchar(512),
 @UseSign int,
 @HandsetCode nvarchar(11),
 @EMailAddr nvarchar(128),
 @PhoneCode nvarchar(128),
 @WebAddr nvarchar(512),
 @UserAdrr nvarchar(512),
 @MailCode nvarchar(6),
 @AddUserID int,
 @AddDate nvarchar(10),
 @AddTime nvarchar(8)
as
 insert Js_User(Js_UserID,Js_UserNumber,Js_UserName,Js_UserPass,Js_UserGroupList,Js_LogonPreceptID,Js_RightID,Js_Desc,Js_UseSign,Js_HandsetCode,Js_EMailAddr,Js_PhoneCode,Js_WebAddr,Js_UserAdrr,Js_MailCode,Js_AddUserID,Js_AddDate,Js_AddTime)
 values(@UserID,@UserNumber,@UserName,@UserPass,@UserGroupList,@LogonPreceptID,@RightID,@Desc,@UseSign,@HandsetCode,@EMailAddr,@PhoneCode,@WebAddr,@UserAdrr,@MailCode,@AddUserID,@AddDate,@AddTime)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO