sql server 查询区分大小写

http://blog.csdn.net/wincol/article/details/1609994

 

某字段需要区分大小写：

ALTER TABLE teacher_info
ALTER COLUMN Teacher_Pass nvarchar(MAX) COLLATE Chinese_PRC_CS_AS