-- 下面的简单语句可以演示数据库兼容级别对collate 的影响USE pubsEXEC sp_dbcmptlevel 'pubs',70 GOselect * from sysobjects where name = 'Wang' collate Chinese_PRC_CS_AS_WS GOEXEC sp_dbcmptlevel 'pubs',80 GOselect * from sysobjects where name = 'Wang' collate Chinese_PRC_CS_AS_WS GO
2. 你的数据库兼容级别必须是>=80, 否则也是不支持的
GOselect * from sysobjects where name = 'Wang' collate Chinese_PRC_CS_AS_WS
GOEXEC sp_dbcmptlevel 'pubs',80
GOselect * from sysobjects where name = 'Wang' collate Chinese_PRC_CS_AS_WS
GO
把qq留下
我想加你