Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BEGIN...END Error
Message
 
 
To
17/06/2008 16:38:33
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Miscellaneous
Thread ID:
01324921
Message ID:
01324923
Views:
10
>IF I comment-out the PRINT line in the code below, I get this error:
>
>Msg 156, Level 15, State 1, Line 233
>Incorrect syntax near the keyword 'FETCH'.
>Msg 102, Level 15, State 1, Line 256
>Incorrect syntax near 'OFF'.
>
>
>
>IF @ProcessDocument = 'N'
>
>	BEGIN
>
>		-- Testing ONLY!
>		--PRINT 'Document Skipped: ' + @FirstFile
>
>	END
>
I tried it and found, that you can not have empty BEGIN/END block. Comment the whole block out /* */ or Ctrl+K/Ctrl+C to put --
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform