SQL GOTO statement using variable label

Question

i was hoping to be able to do something like this:

declare @label varchar
set @label = 'label_1'
goto @label

label_1:

label_2:

of course, sql server gives me an incorrect syntax error... so i was wondering if i can still do this with a slightly different syntax?

Answer 1

Why not simply use an if/else?

Answer 2

not tested but does exec("goto "+@label) work ?

Answer 3

You can only do this if you dynamically build the SQL statement.

GOTOs are best avoided though - mainly for code readability.

Answer 4

As far as I know, you cannot parameterize GOTO. You can do that if you use Dynamic SQL.