Collation Sequences | Varinder Sandhu

SQL Server 2008 R2- Find Database Collation

Varinder Sandhu SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

How to find collation of current database? There are two different ways to find out SQL Server database collation. Using T-SQL SELECT DATABASEPROPERTYEX('Database_Name', 'Collation') as SQLCollation; Using SQL Server Management Studio (SSMS) Right Click on the database Go to Properties You will get the dialog box as shown in the

» Read more

Collation Sequences, fn_helpcollations

SQL Server – Collation Sequences

Varinder Sandhu SQL, SQL-Advanced, Varinder Sandhu

Collation sequence control how server treats character data for storage, retrieval, and sorting and comparison operation. SQL Server 2008 allows you to specific sequence to support any language currently used around the word. Collation sequence can be specified at instance, database, table and column level. The only collation sequence that

» Read more

Collation Sequences, Latin1_General_CI_AS, SQL, SQL Server