存储过程(修改用户信息是否已存在用户名)

alter proc existsUser(@userId int,@userName varchar(20))
as
begin
if(@userId != 0)
begin
declare @name varchar(20)
select top 1 @name=H_Email from HFL_member where H_ID=@userId
if(@userName = @name)
begin
print '能更新'
return 1--能更新
--更新需要且除Email的其他数据
end
else
begin
declare @num int
select @num=count(1) from HFL_member where H_Email=@userName
if(@num<1)
begin
print '能更新'
return 1--能更新
end
else
begin
print '不能更新'
return 2--不能更新
end
end
end
else