COLLATE的更改

最新推荐文章于 2025-03-27 15:33:54 发布

weixin_30896763

最新推荐文章于 2025-03-27 15:33:54 发布

阅读量349

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/chnch/archive/2011/11/16/2251166.html

版权

--修改数据库的COLLATE
ALTER DATABASE LNS_Develop2 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
alter database LNS_Develop2 COLLATE Chinese_PRC_CS_AS_WS
ALTER DATABASE LNS_Develop2 SET MULTI_USER
--修改已存在的字段。这段还报“Ad hoc updates to system catalogs are not allowed.”的错误不知道为什么?
--select distinct collationid,collation from syscolumns
EXEC sp_configure 'allow updates',1 RECONFIGURE WITH OVERRIDE
update syscolumns set collationid =16420,collation='Chinese_PRC_CS_AS_WS' where collationid in (0,16420,4104,65544,53284)
EXEC sp_configure 'allow updates',0 RECONFIGURE WITH OVERRIDE

转载于:https://www.cnblogs.com/chnch/archive/2011/11/16/2251166.html