procdeletemember_givepower.sql

扬州升瑞售楼系统2000扬州升瑞售楼系统2000扬州升瑞售楼系统2000扬州升瑞售楼系统2000扬州升瑞售楼系统2000

Alter proc procDeleteMember_GivePower
            @MemberName varchar(20),
            @ElectDeleted varchar(12) output  --删除成功时返回‘成功’
As
               select @ElectDeleted='不能成功删除'          
               Declare @a int,@b int
               select @a=count(*) from comember where 姓名=@MemberName  
               if @a=0 select @ElectDeleted='没有这个用户'  
               if @a=1 
                       begin
                             begin tran DeleteData
                                        delete  from comember where 姓名=@MemberName
                                    --     select @b=count(*) from UserRoles where 用户名=@MemberName
                                    --      if @b=0    --角色表中没有这个用户
                                    --      if @b=1         
                                    --                   begin 
                                        delete from UserRoles where 用户名=@MemberName
                                    --                   end 
                                         select @ElectDeleted='删除成功！'
                             commit tran
                       end  
Go