是:
create proc upgrade_user_status
@user_id int,
@admin_id int,
@admin_pwd varchar(12),
@status_str varchar(20)
as
declare @pwd varchar(12)
select @pwd=password from users where user_id=@admin_id and status like '财务人员'
if @pwd=@admin_pwd
update users
set status=@status_str
where user_id=@user_id
select re_info='ok'
else
select re_info='您没有足够的权限改变会员身份!'
create proc upgrade_user_status
@user_id int,
@admin_id int,
@admin_pwd varchar(12),
@status_str varchar(20)
as
declare @pwd varchar(12)
select @pwd=password from users where user_id=@admin_id and status like '财务人员'
if @pwd=@admin_pwd
update users
set status=@status_str
where user_id=@user_id
select re_info='ok'
else
select re_info='您没有足够的权限改变会员身份!'
begin
update users
set status=@status_str
where user_id=@user_id
select re_info='ok'
end
else
select re_info='您没有足够的权限改变会员身份!'建议你看看SQL Server联机丛书,在索引里面输入关键字:BEGIN
begin
update users
set status=@status_str
where user_id=@user_id
select re_info='ok'
end
else
select re_info='您没有足够的权限改变会员身份!'