Execute Dynamic Query with go in sql

by

GO is actually not valid T-SQL:

GO is not a Transact-SQL statement; it is a command recognized by the
sqlcmd and osql utilities and SQL Server Management Studio Code
editor.

You will have to remove instances of GO in your dynamic SQL, or use one of the tools mentioned on the article (such as osql from the command-line). Your query should still work with all instances of GO removed from the dynamic SQL.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. sql server 2008 management studio not checking the syntax of my query
  3. Is the NOLOCK (Sql Server hint) bad practice?
  4. How to create a table from select query result in SQL Server 2008 [duplicate]
  5. Where value in column containing comma delimited values
  6. Parse comma-separated string to make IN List of strings in the Where clause
  7. How to use table variable in a dynamic sql statement?
  8. OPTION (RECOMPILE) is Always Faster; Why?
  9. Create Trigger to log SQL that affected table?
  10. Rename column SQL Server 2008
  11. Transfer data from one database to another database
  12. Compare DATETIME and DATE ignoring time portion
  13. Split function in SQL Server 2008
  14. Remove numbers from string sql server
  15. How to find third or nᵗʰ maximum salary from salary table?
  16. SQL “between” not inclusive
  17. Can I set ignore_dup_key on for a primary key?
  18. Selecting first row per group
  19. Using PIVOT in SQL Server 2008
  20. How do I prevent a database trigger from recursing?
  21. sql group by only rows which are in sequence
  22. Function in SQL Server 2008 similar to GREATEST in mysql?
  23. Converting Select results into Insert script – SQL Server
  24. How to retrieve field names from temporary table (SQL Server 2008)
  25. When using GETDATE() in many places, is it better to use a variable?
  26. Executing SQL Server Agent Job from a stored procedure and returning job result
  27. Select SQL Server database size
  28. Backup a single table with its data from a database in sql server 2008
  29. COALESCE Function in TSQL
  30. Try_Convert for SQL Server 2008 R2

Leave a Comment