查找SQL实例和数据库的排序规则

Find Collations For Your SQL Instance And The Databases

TIME STAMP

Contents

• 中文
• English
• SQL Logic
• Build Info
• Author
• License

中文

这是获取SQL Server排序规则（实例排序规则）和数据库排序规则的一些SQL逻辑（logic）。

English

Here’s some sql logic to get the SQL Server Collation ( Instance Collation ), and the Database Collation.

Logic

use master;
set nocount on
declare @mydatabasename     varchar(255)
set     @mydatabasename     = 'msdb'  -- I'm using MSDB as an example
select
    'server name'           = serverproperty('servername')
,   'server collation'      = convert(varchar, serverproperty('collation'))
,   'database name'         = @mydatabasename
,   'database collation'    = databasepropertyex(@mydatabasename, 'collation');

以下是截图。
Here’s a quick screenshot.

Build-Info

Build Quality	Build History

Author

• 李聪明的数据库 Lee’s Clever Data
• Mike的数据库宝典 Mikes Database Collection
• 李聪明的数据库 “Lee Songming”

License