Handling "GO" Separators in SQL Scripts - the easy way
Posted by: JonGalloway.ToString(),
on 07 Nov 2006 |
View original | Bookmarked: 0 time(s)
If you've ever had to execute one or more SQL scripts from ADO.NET, you've likely run into the GO batch terminator issue. Any SQL script that does anything worthwhile has more than one batch, separated by a GO terminator. The problem is that "GO" isn't valid T-SQL, it's just a command used by the SQLCMD, OSQL and ISQL utilities that can also be used within Query Analyzer and the Query Editor window. If you try to execute T-SQL scripts with GO commands in them via ADO.NET...