更改数据库排序规则后,表中字段的排序规则仍然没变,如果在企业管理器中在设计表的界面去一个字段一个字段的改太累人了, EXEC sp_configure 'allow updates',1 RECONFIGURE WITH OVERRIDEupdate dbo.syscolumns set collationid=65572 where collationid=53284EXEC sp_configure 'allow updates',0 RECONFIGURE WITH OVERRIDE go
EXEC sp_configure 'allow updates',1 RECONFIGURE WITH OVERRIDEupdate dbo.syscolumns set collationid=65572 where collationid=53284EXEC sp_configure 'allow updates',0 RECONFIGURE WITH OVERRIDE
go