SQL GOTO statement in a script with multiple GO

Question

I need to exit a SQL script without an error if a certain condition holds true. I've read that 1 solution would be to raiseerror with error code 20+ and with log parameter. But the limitation for that is that i can execute that only as an admin and the connection to the db will be aborted.

Also, I tried using GOTO and jump to the end-of-the-script, but it doesnt work, because I have multiple GO in the middle of the script. Is there a another solution?

IF <some condition> BEGIN GOTO Finished; END GO

Finished: SELECT 'Done'

Thanks!

There is no `GOTO` in SQL. Did you perhaps mean a specific dialect? — Ignacio Vazquez-Abrams, Oct 11 '10 at 20:00
yeah, t-sql. If I declare the label before I jump to it, then everything is ok. Otherwise, it complains that it is undeclared — kateroh, Oct 11 '10 at 20:13

score 4 · Accepted Answer · answered Oct 11 '10 at 20:22

4

goto cannot jump past a go. You'd have to retest the condition in each block:

IF NOT <some condition> 
BEGIN
   ...
END
GO
IF NOT <some condition> 
BEGIN
   ...
END
GO
IF NOT <some condition> 
...

answered Oct 11 '10 at 20:22

Andomar

232,371
49
380
404

1

+1, it is either this or use `EXEC(@SQL)` for this things that need the GO, and then you can use the `GOTO`. – KM. Oct 11 '10 at 20:38

SQL GOTO statement in a script with multiple GO

1 Answers1