Declaring table variables-Is this working as designed or is this a quirk or is this a a bug?

• Chrissy321

  SSCoach

  Points: 15763

  More actions

  March 14, 2012 at 2:30 pm

  #265832

  I am surprised that the first set of statements work but the second set do not.

  Is this working as designed or is this a quirk or is this a a bug?

  DECLARE @test-2 char(1)

  DECLARE @testtable TABLE (Test char(1))

  DECLARE

  @test-2 char(1),

  @testtable TABLE (Test char(1))

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 14, 2012 at 2:44 pm

  #1459497

  Looks like each table variable needs to be declared separately, just like creating tables.