Curley Braces in T/SQL?

• bbradley

  Old Hand

  Points: 393

  More actions

  June 9, 2008 at 8:54 pm

  #70851

  Has anyone seen the following syntax in T/SQL?

  SELECT ReqPro.RqUserDefinedFieldValues.*

  , ReqPro.RqOverflowValues.OverflowFieldValue

  FROM

  {oj

  ReqPro.RqUserDefinedFieldValues

  LEFT OUTER JOIN ReqPro.RqOverflowValues

  ON (ReqPro.RqUserDefinedFieldValues.RequirementId= ReqPro.RqOverflowValues.OverflowRequirementId)

  AND (ReqPro.RqUserDefinedFieldValues.FieldId= ReqPro.RqOverflowValues.OverflowFieldId)

  }

  WHERE ReqPro.RqUserDefinedFieldValues.RequirementID=47

  ORDER BY ReqPro.RqUserDefinedFieldValues.FieldID

  I was wondering exactly why the CurleyBraces and "oj"?

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  June 10, 2008 at 12:27 am

  #826457

  Duplicate post

  http://www.sqlservercentral.com/Forums/Topic514126-8-1.aspx

  ---

  N 56°04'39.16"
  E 12°55'05.25"