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