T-SQL Syntax Gotchas

• Sean of the Lynchmob

  Ten Centuries

  Points: 1038

  More actions

  July 9, 2014 at 2:41 am

  #1727964

  Thank you, a nice puzzle to work out first thing in the morning. Close, though, I had forgotten that 'COMPUTE' had been deprecated and had to think about that one.

  Thanks,

  Sean

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  July 9, 2014 at 3:23 am

  #1727971

  Toreador (7/8/2014)

  ---

  Gazareth (7/8/2014)

  ---

  Toreador (7/8/2014)

  ---

  Being pedantic, only 3 of those statements return syntax errors...

  Are you running it on SQL 2008 R2 or earlier?

  Statement 6 is valid there but not on 2012 onwards.

  SQL2014.

  Statement 3 fails with "An object or column name is missing or empty...."

  The others fail with a syntax error.

  I did say I was being pedantic

  Gotcha. I didn't parse your statement correctly

• manik_anu

  SSCrazy

  Points: 2397

  More actions

  July 15, 2014 at 2:06 am

  #1729348

  I am running at sql server 2008 R2... for section 6 i didn't get any error....

  Manik
  You cannot get to the top by sitting on your bottom.

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  July 15, 2014 at 7:52 am

  #1729460

  manik123 (7/15/2014)

  ---

  I am running at sql server 2008 R2... for section 6 i didn't get any error....

  The question states that the script was run against a 2012 instance. Section 6 will fail on 2012 and above.

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]

• PChiragS

  SSCarpal Tunnel

  Points: 4965

  More actions

  August 4, 2014 at 12:00 pm

  #1734919

  nice question.

  thanks Sean.