Is there a SQL I can execute to find out?
是否有一个SQL我可以执行以发现?
3 个解决方案
#1
28
The server default collation:
服务器的默认排序规则:
select serverproperty('collation')
Which is the same as
哪个和
select databasepropertyex('master','collation')
Check SERVERPROPERTY in Books Online for other information you can get about the server (instance).
在Books Online中检查SERVERPROPERTY以获取关于服务器(实例)的其他信息。
#2
10
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') SQLCollation;
Just substitute your DB name for 'AdventureWorks'. Or use DB_NAME:
只需将DB名称替换为“AdventureWorks”即可。或者使用DB_NAME:
SELECT DATABASEPROPERTYEX(DB_NAME(), 'Collation') SQLCollation;
#3
1
This is the official doc given by MS, hope it helps. http://msdn.microsoft.com/en-us/library/hh230914.aspx#TsqlProcedure
这是微软的官方文件，希望它能有所帮助。http://msdn.microsoft.com/en-us/library/hh230914.aspx TsqlProcedure
#1
28
The server default collation:
服务器的默认排序规则:
select serverproperty('collation')
Which is the same as
哪个和
select databasepropertyex('master','collation')
Check SERVERPROPERTY in Books Online for other information you can get about the server (instance).
在Books Online中检查SERVERPROPERTY以获取关于服务器(实例)的其他信息。
#2
10
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') SQLCollation;
Just substitute your DB name for 'AdventureWorks'. Or use DB_NAME:
只需将DB名称替换为“AdventureWorks”即可。或者使用DB_NAME:
SELECT DATABASEPROPERTYEX(DB_NAME(), 'Collation') SQLCollation;
#3
1
This is the official doc given by MS, hope it helps. http://msdn.microsoft.com/en-us/library/hh230914.aspx#TsqlProcedure
这是微软的官方文件，希望它能有所帮助。http://msdn.microsoft.com/en-us/library/hh230914.aspx TsqlProcedure