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 6:32 PM by kg4afy
Change 27754 has resolved this issue.

comments

fritogotlayed wrote Feb 20, 2009 at 4: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 6:32 PM

wrote Feb 1, 2013 at 3:56 AM

wrote May 14, 2013 at 1:53 AM