Stored Procedures: OUTPUT vs OUT?

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  September 29, 2010 at 9:07 am

  #241024

  I've seen in BOL under the section regarding Stored Procedures, specifically declaring OUTPUT parameters, where both "OUTPUT" and "OUT" are used.

  Is there a difference or is "OUT" an abbreviation for OUTPUT similar to "CREATE Proc" = "CREATE Procedure"?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  September 29, 2010 at 9:17 am

  #1229136

  This [ OUT | OUTPUT ] implies that either can be used. The Pipe "|" is an "or" character.

  Example E shows both being used http://msdn.microsoft.com/en-us/library/ms187926%28v=SQL.100%29.aspx

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  September 29, 2010 at 9:30 am

  #1229151

  Thanks Steve. That was my interpretation as well that the pipe indicates "or" -- I just needed confirmation.