Which collation will be assigned?

You are working with a SQL Server 2008 instance that is configured to use the Latin1_General_CS_AS collation. You create a database by using the following statements.

CREATE DATABASE TestDB COLLATE Estonian_CS_AS;
GO
USE TestDB;
GO
CREATE TABLE TestPermTab (PrimaryKey int PRIMARY KEY, Col1 nchar );

You implement a temporary table named #TestTempTab that uses the following code.

use TestDB;
GO
CREATE TABLE #TestTempTab (PrimaryKey int PRIMARY KEY, Col1 nchar );
INSERT INTO #TestTempTab
SELECT * FROM TestPermTab;

You need to identify which collation will be assigned to #TestTempTab. Which collation will be assigned?

You are working with a SQL Server 2008 instance that is configured to use the Latin1_General_CS_AS collation. You create a database by using the following statements.

CREATE DATABASE TestDB COLLATE Estonian_CS_AS;
GO
USE TestDB;
GO
CREATE TABLE TestPermTab (PrimaryKey int PRIMARY KEY, Col1 nchar );

You implement a temporary table named #TestTempTab that uses the following code.

use TestDB;
GO
CREATE TABLE #TestTempTab (PrimaryKey int PRIMARY KEY, Col1 nchar );
INSERT INTO #TestTempTab
SELECT * FROM TestPermTab;

You need to identify which collation will be assigned to #TestTempTab. Which collation will be assigned?

A.
No-collation

B.
Estonian_CS_AS

C.
Latin1_General_CS_AS

D.
The collation selected by the Windows system locale of the server



Leave a Reply 0

Your email address will not be published. Required fields are marked *