Collation

SQL SERVER : How To Change Collation for all Table Columns.

SQL SERVER : How To Change Collation for all Table Columns.

 Change Collation for all Tables columns: Here in this article will see how we can modify the collation of our database tables column. In our previous article have explained how we can find the collation of database with a simple SQL Script in SQLSERVER. Here in this example, we set i.e alter collation all tables columns as SQL_Latin1_General_CP1_CI_AS […]


by - Satinder singh

Find collation of database [SQL SERVER]

Find collation of database [SQL SERVER]

SQL Server Find Collation of Database: Here in this article we see how to find the collation of particular Database in SQL server 2008 r2. Finding Collation of SQL Server is very helpful when you need to change the Collation at the Database Level.  Assume you have to join two different table from two different Database Server, […]


by - Satinder singh