Table Variable question

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  July 7, 2003 at 12:32 pm

  #160516

  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

• mccork

  SSC-Insane

  Points: 22288

  More actions

  July 8, 2003 at 6:50 am

  #464477

  B) SQL_Latin1_General_CP1_CI_AS

  
  Cheers,
  - Mark