create procedure LoginSystem_Verify_Password(
@userid nvarchar(20),
@password varchar(50)
)
as
begin
Select UserId From Login
Where UserID collate chinese_prc_CS_Ai =@userid and [Password]=@password
end
@userid nvarchar(20),
@password varchar(50)
)
as
begin
Select UserId From Login
Where UserID collate chinese_prc_CS_Ai =@userid and [Password]=@password
end
select cast('aA' as binary)
if cast('aa' as binary)<> cast('aA' as binary)
print '区分大小写'
alter table Login alter column UserID Nvarchar(50) collate chinese_prc_cs_as