declare @Tmp1 table(Field varchar(10)) insert @Tmp1 select 'A' union all select 'a' union all select 'B' union all select 'A' Select * From @Tmp1 Where Field='a' COLLATE Chinese_PRC_CS_AS/*结果 Field ---------- a */
select * from @a where [Field]='a' collate Chinese_PRC_BIN
insert @Tmp1
select 'A' union all
select 'a' union all
select 'B' union all
select 'A'
Select * From @Tmp1 Where Field='a' COLLATE Chinese_PRC_CS_AS/*结果
Field
----------
a
*/