if exists (select * from dbo.employees where cast(loginname as varbinary)=cast(@loginname as varbinary) and cast([password] as varbinary)=cast(@password as varbinary))
if exists (select * from dbo.employees where cast(loginname as varbinary)=cast(@loginname as varbinary) and cast([password] as varbinary)=cast(@password as varbinary))
declare @rc int /* SP return code */
set nocount on
select @rc = 0
if @rc = 0
begin
if exists (select * from dbo.employees where loginname=@loginname and [password]=@password)
begin
select @rc=0
return @rc
end
else
select @rc=-1
return @rc
end
GO
Declare @p varchar(10)
Declare @v varchar(10)
set @v='NIPSAN'
set @p='Nipsan'
IF CAST(@v as varbinary)=CAST(@p as varbinary)
print '相等'
else
print '不等'
Declare @p varchar(10)
Declare @v varchar(10)
set @v='NIPSAN'
set @p='Nipsan'
IF CAST(@v as varbinary)=CAST(@p as varbinary)
print '相等'
else
print '不等'
Declare @p varchar(10)
Declare @v varchar(10)
set @v='NIPSAN'
set @p='Nipsan'
IF CAST(@v as varbinary)=CAST(@p as varbinary)
print '相等'
else
print '不等'