SQL Server-查询区分大小写

1.区分大小写--一笔记录

select * from hph where  row_id COLLATE CHINESE_PRC_CS_AS='AAAoOTAAMAAABJTAAM';

2.不区分大小写--两笔记录

select * from hph where  row_id COLLATE CHINESE_PRC_Ci_AS='AAAoOTAAMAAABJTAAM';