You are working with a SQL Server 2008 instance that is configured to use the Icelandic_CS_AS collation. You create a database by using code that includes the following statements.
CREATE DATABASE InternationalDB COLLATE Japanese_CS_AS;
GO
USE InternationalDB;
GO
CREATE TABLE AppPermTable (PrimaryKey int PRIMARY KEY, AppID nchar );
You implement a temporary table named #AppTempTable that uses the following code.
USE InternationalDB;
GO
CREATE TABLE #AppTempTable (PrimaryKey int PRIMARY KEY, AppID nchar );
INSERT INTO #AppTempTable SELECT * FROM AppPermTable;
You need to identify the collation that will be assigned to #AppTempTable.
Which collation will be assigned?
A. Icelandic_CS_AS
B. No collation
C. The collation selected by the Windows system locale of the server
D. Japanese_CS_AS
