修改排序規則表
ALTER TABLE tb
ALTER COLUMN colname nvarchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS数据库
ALTER DATABASE database
COLLATE SQL_Latin1_General_CP1_CI_AS
ALTER TABLE tb
ALTER COLUMN colname nvarchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS数据库
ALTER DATABASE database
COLLATE SQL_Latin1_General_CP1_CI_AS
EXEC master..sp_configure 'allow updates', '1'
RECONFIGURE WITH OVERRIDE
go
update syscolumns set collationid = 53284
where collation like 'Japanese%'
EXEC master..sp_configure 'allow updates', '0'
RECONFIGURE WITH OVERRIDE
go
Msg 259, Level 16, State 1, Line 5
Ad hoc updates to system catalogs are not allowed.
我使用的是express,跟这个有关系吗