-
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
一个检测用户名是否存在