SQL Server 添加/修改（用户名重复）存储过程

 

ALTER PROCEDURE [dbo].[up_Tb_SysUser_AddEdit]
@return int output,//用于判断重复
@id nvarchar(40),
@username nvarchar(20),
@realname nvarchar(20),
@createuser nvarchar(40),
@createtime datetime,
@isdel int
AS
set @return=1;
if @id='' or @id is null --添加
BEGIN
if exists(select * from Tb_SysUser where UserName=@username and Isdel=@isdel)
set @return=-2;
else
insert into Tb_SysUser(
            [ID]
           ,[UserName]
           ,[RealName] 
           ,[CreateUser]
           ,[CreateTime]
           ,[Isdel])
values(
NEWID(),@username,@realname,@createuser,@createtime,@isdel)
END
else
begin
if exists(select * from Tb_SysUser where UserName=@username and Isdel=@isdel and @id<>ID)
set @return=-2;
else
update Tb_SysUser 
set UserName=@username,
RealName=@realname
where ID=@ID
end