Help with labels

• pop022

  Old Hand

  Points: 356

  More actions

  October 2, 2003 at 1:46 pm

  #160878

  I am attempting to use the goto statement with a variable.

  I.E.

  CREATE PROCEDURE dbo.test

  @label VARCHAR(20)

  AS

  GOTO @label

  Step2:

  PRINT 'This is Step2'

  GO

  If @label was Step2 I want it to print This is Step2. Does anyone know how to do this? If you run this code it will report invalid syntax near @label. Any help would be appreciated. Thanks.

• mccork

  SSC-Insane

  Points: 22288

  More actions

  October 2, 2003 at 5:12 pm

  #476891

  I'm afraid you can't use a variable in this manner

  Cheers,

  - Mark

  
  Cheers,
  - Mark

• pop022

  Old Hand

  Points: 356

  More actions

  October 2, 2003 at 7:16 pm

  #476897

  That's what I thought. I used IF statements instead. Thanks for your help.