set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[SaveUser] @UserName nvarchar(1000), @GroupID int, @SecureLevel tinyint, @PassWord nvarchar(4000), @UID int Output, @NoPassUpdate bit=0, @Disable bit =null AS if @Uid=0 If exists (select * from Users where uname=@USERNAME) begin Raiserror (50701,16,1) return 0 end Else Begin INSERT INTO Users (UName, GID, SecureLevel, PassWord, Disable) VALUES (@UserName,@GroupID,@SecureLevel,@PassWord,@Disable) set @UID=(select IDENT_CURRENT('Users')) END else begin if @Disable is null select @Disable=Disable from users WHERE (UID = @UID) if @NoPassUpdate =1 UPDATE Users SET UName = @UserName, GID = @GroupID, SecureLevel = @SecureLevel, Disable =@Disable WHERE (UID = @UID) else UPDATE Users SET UName = @UserName, GID = @GroupID, SecureLevel = @SecureLevel, PassWord = @PassWord, Disable = @Disable WHERE (UID = @UID) end