How To Specify the Collation for a Character Data Type in MS SQL Server?
Submitted by: AdministratorIf you do not want to use the default collation provided by the SQL Server, you can use the "COLLATE collation_name" clause to specify a different collation to be used at different levels:
* Database Level - Used in CREATE DATABASE or ALTER DATABASE statements to set a new default collation for the entire database.
* Table Column Level - Used in CREATE TABLE or ALTER TABLE statements to override the database default collation for this column.
* Character String Expression Level - Used at the end of the expression to cast the expression to the specified collation.
Submitted by: Administrator
* Database Level - Used in CREATE DATABASE or ALTER DATABASE statements to set a new default collation for the entire database.
* Table Column Level - Used in CREATE TABLE or ALTER TABLE statements to override the database default collation for this column.
* Character String Expression Level - Used at the end of the expression to cast the expression to the specified collation.
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | How To Start SQL Server Browser Service? |
☺ | How To Execute the Cursor Queries with "OPEN" Statements? |
☺ | How To Test ODBC DSN Connection Settings? |
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
☺ | How To Create a Testing Table with Test Data in MS SQL Server? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |