You can use SERVERPROPERTY for instance collation and use DATABASEPROPERTYEX for database collation.
select SERVERPROPERTY('Collation') as Instance_Collation;
select DATABASEPROPERTYEX('pubs', 'Collation') DB_Collation;
You can use SERVERPROPERTY for instance collation and use DATABASEPROPERTYEX for database collation.
select SERVERPROPERTY('Collation') as Instance_Collation;
select DATABASEPROPERTYEX('pubs', 'Collation') DB_Collation;
Vincent Rainardi's blog on Data Warehousing and Data Science
Mustafa Acungil
Değişimi okumak, anlamak ve yaşamak için
T-SQL tips and tricks, best practices and query plans from the field.
Data Engineering 