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 Find Out What Is the Default Collation in a Database?
Submitted by: AdministratorThe default collation of a database comes from the server if you are not using the COLLATE clause in the CREATE DATABASE statement. If you are not using the COLLATE clause for character string column, it will use the default collation from the database. Using this logic, you can find out the default collation in a database or server very easily. See the following tutorial exercise:
CREATE DATABASE GlobalGuideLineDatabase
GO
CREATE TABLE faq (Name VARCHAR(80))
GO
SP_HELP FAQ
GO
Column_name ... Collation
Name ... SQL_Latin1_General_CP1_CI_AS
Now we know that the default collation for SQL Server 2005 is SQL_Latin1_General_CP1_CI_AS.
Submitted by: Administrator
CREATE DATABASE GlobalGuideLineDatabase
GO
CREATE TABLE faq (Name VARCHAR(80))
GO
SP_HELP FAQ
GO
Column_name ... Collation
Name ... SQL_Latin1_General_CP1_CI_AS
Now we know that the default collation for SQL Server 2005 is SQL_Latin1_General_CP1_CI_AS.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.