默认的排序规则 已有的表不改变
USE master
GOALTER DATABASE [MK_UboxChs] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
alter database [MK_UboxChs] COLLATE Chinese_PRC_CS_AS
ALTER DATABASE [MK_UboxChs] SET MULTI_USER
go
sql server区分大小写
ALTER DATABASE [MK_UboxChs] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
alter database [MK_UboxChs] COLLATE Chinese_PRC_CS_AS
ALTER DATABASE [MK_UboxChs] SET MULTI_USER
go
本文转载:CSDN博客