我们的SQL SERVER 200 是二进制的,默认查询区分大小写,为了查询不分大小写,我在网上查了一下语法(SQL语句如下示),结果运行,显示语法错误,请高人纠正,谢谢.
select * from 印字 where YZ01 like '%utp%' ORDER BY CODE DESC collate Chinese_PRC_CI_AI--
select * from 印字 where YZ01 like '%utp%' ORDER BY CODE DESC collate Chinese_PRC_CI_AI--
select * from 印字
where YZ01 like '%utp%' collate Chinese_PRC_CI_AI
ORDER BY CODE DESC