Avoid This Common Stored Procedure Mistake in SQL Server Using GO
When writing or modifying stored procedures, functions, or triggers, I often see developers get tripped up by strange compiler errors that have nothing to do with SQL itself and everything to do with improper batching. “Incorrect syntax near ‘CREATE PROCEDURE’. Expecting ‘END’.” If you check the image below, you’ll see…