一个检测用户名是否存在 的sql

一个检测用户名是否存在

SQL code

ALTER procedure [ dbo ] . [ GetISExistsByName ]
@StaffName nvarchar ( 50 ),
@out int output
as
set @out = 1
if not exists ( select * from LiveChainCSWeb.dbo.LC_Staff where Usertype_ID = 3 and StaffName = @StaffName )
begin

set @out = 0

end

转载于:https://www.cnblogs.com/virusswb/articles/1233744.html