[dba-SQLServer]Table variable question

Billy Pang tuxedo_man at hotmail.com
Mon Jul 7 13:44:55 CDT 2003


Question regarding the table variable:

In a SQL Server install, we have the following:
Server collation: Latin1_General_CI_AS
Database collation: SQL_Latin1_General_CP1_CI_AS

If you create a table variable with a varchar field, what collation is it?

A) Latin1_General_CI_AS
B) SQL_Latin1_General_CP1_CI_AS

Is it A) or B)?

thanks in advance,
Billy

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail



More information about the dba-SQLServer mailing list