1

Closed

Script run fails with GOTO

description

Script parsing cuts procs in half when GOTO is encountered... example failure proc below.
 
proc attached.

file attachments

Closed May 27, 2009 at 7:32 PM by kg4afy
Change 27754 has resolved this issue.

comments

fritogotlayed wrote Feb 20, 2009 at 5:01 AM

While this is a problem there is a quick, easy way to get around it. Wrap the "problem" statements in the line below. Don't forget to escape your single ticks by doubling them up!

EXEC dbo.sp_executesql @statement = N'
CREATE PROCEDURE...
...
END'

wrote May 27, 2009 at 7:32 PM

wrote Feb 1, 2013 at 4:56 AM

wrote May 14, 2013 at 2:53 AM