Using “GO” within a transaction

by

GO is not a SQL keyword.

It’s a batch separator used by client tools (like SSMS) to break the entire script up into batches

You’ll have to break up the script into batches yourself or use something like sqlcmd with “-c GO” or osql to deal with “GO”

More Related Contents:

  1. Using a variable for table name in ‘From’ clause in SQL Server 2008
  2. SQL Identity (autonumber) is Incremented Even with a Transaction Rollback
  3. What’s a good way to trim all whitespace characters from a string in T-SQL without UDF and without CLR?
  4. Correct use of transactions in SQL Server
  5. Does End Using close an open SQL Connection
  6. Does this code prevent SQL injection?
  7. TSQL md5 hash different to C# .NET md5
  8. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  9. How can you name the Dataset’s Tables you return in a stored proc?
  10. Implementing transactions over multiple databases
  11. Generating sql code programmatically
  12. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  13. Convert Month Number to Month Name Function in SQL
  14. How to do SQL Like % in Linq?
  15. Multiple INSERT statements vs. single INSERT with multiple VALUES
  16. Limit on the WHERE col IN (…) condition
  17. Removing leading zeroes from a field in a SQL statement
  18. Getting result of dynamic SQL into a variable for sql-server
  19. Better techniques for trimming leading zeros in SQL Server?
  20. Update primary key value using entity framework
  21. SQL error: Incorrect syntax near the keyword ‘User’
  22. SQL Server SELECT into existing table
  23. SQL Select Upcoming Birthdays
  24. How can I include null values in a MIN or MAX?
  25. How to solve “unable to switch the encoding” error when inserting XML into SQL Server
  26. How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?
  27. Unable to load DLL ‘SqlServerSpatial.dll’
  28. Date serial in SQL?
  29. SQL Server: +(unary) operator on non-numeric Strings
  30. Parameterise table name in .NET/SQL?

Leave a Comment