sql语句脚本的创建

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[InsertTB_UserInfo]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
  DROP PROCEDURE [dbo].[InsertTB_UserInfo]
 go
create Procedure [dbo].[InsertTB_UserInfo]
 @UserJobNumber nvarchar(20),
 @UserSex int,
 @UserName nvarchar(10),
 @UserLoginName nvarchar(20),
 @UserLoginPwd nvarchar(20),
 @InstID int,
 @DepaID int,
 @UserTelephone nvarchar(20),
 @UserExtphone nvarchar(10),
 @MobilePhone nvarchar(11),
 @UserEmail nvarchar(50),
 @UserMemo nvarchar(1000),
 @DelFlag int,
 @CreateDate datetime,
 @DeleteDate datetime
As
Begin
 Insert Into TB_UserInfo
  ([UserJobNumber],[UserSex],[UserName],[UserLoginName],[UserLoginPwd],[InstID],[DepaID],[UserTelephone],[UserExtphone],[MobilePhone],[UserEmail],[UserMemo],[DelFlag],[CreateDate],[DeleteDate])
 Values
  (@UserJobNumber,@UserSex,@UserName,@UserLoginName,@UserLoginPwd,@InstID,@DepaID,@UserTelephone,@UserExtphone,@MobilePhone,@UserEmail,@UserMemo,@DelFlag,@CreateDate,@DeleteDate)
 Select @@IDENTITY

 

End