Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
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
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.