Incorrect syntax near ‘GO’

by

The GO keyword is not T-SQL, but a SQL Server Management Studio artifact that allows you to separate the execution of a script file in multiple batches.I.e. when you run a T-SQL script file in SSMS, the statements are run in batches separated by the GO keyword. More details can be found here: https://msdn.microsoft.com/en-us/library/ms188037.aspx

If you read that, you’ll see that sqlcmd and osql do also support GO.

SQL Server doesn’t understand the GO keyword. So if you need an equivalent, you need to separate and run the batches individually on your own.

More Related Contents:

  1. Connection to SQL Server Works Sometimes
  2. SQL Server: Isolation level leaks across pooled connections
  3. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  4. Where clause not working in sql server
  5. T-SQL stored procedure that accepts multiple Id values
  6. How do I escape a percentage sign in T-SQL?
  7. Using RegEx in SQL Server
  8. What is the best way to auto-generate INSERT statements for a SQL Server table?
  9. How to get first and last day of previous month (with timestamp) in SQL Server
  10. CTE to get all children (descendants) of a parent
  11. How do I use the CONCAT function in SQL Server 2008 R2?
  12. EXEC sp_executesql with multiple parameters
  13. SQL Server – Dynamic PIVOT Table – SQL Injection
  14. SSIS reading LF as terminator when its set as CRLF
  15. Change type of a column with numbers from varchar to int
  16. Get row where datetime column = today
  17. ‘Incorrect SET Options’ Error When Building Database Project
  18. Create Stored Procedures using Entity Framework Code First?
  19. SQL Server – How to insert a record and make sure it is unique
  20. Full text catalog/index search for %book%
  21. “If not exists” fails on SQL CE
  22. Does the `nodes()` method keep the document order?
  23. Why insert-select to variable table from XML variable so slow?
  24. Set database name dynamically in SQL Server stored procedure?
  25. Slow query with cfqueryparam searching on indexed column containing hashes
  26. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  27. Docker SQL bind: An attempt was made to access a socket in a way forbidden by its access permissions
  28. Generate MD5 hash string with T-SQL
  29. Why can’t Entity Framework see my Stored Procedure’s column information?
  30. How to avoid SSIS FTP task from failing when there are no files to download?

Leave a Comment