TSQL – How to use GO inside of a BEGIN .. END block?

by

I had the same problem and finally managed to solve it using SET NOEXEC. 

IF not whatever
BEGIN
    SET NOEXEC ON; 
END

ALTER TABLE dbo.EMPLOYEE ADD COLUMN EMP_IS_ADMIN BIT NOT NULL
GO
UPDATE dbo.EMPLOYEE SET EMP_IS_ADMIN = whatever

SET NOEXEC OFF;

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Is it possible to write single query on two table which are not connected to each other?
  3. CROSS JOIN vs INNER JOIN in SQL
  4. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  5. Multiple INSERT statements vs. single INSERT with multiple VALUES
  6. Split function equivalent in T-SQL?
  7. Is the NOLOCK (Sql Server hint) bad practice?
  8. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  9. Where value in column containing comma delimited values
  10. Parse comma-separated string to make IN List of strings in the Where clause
  11. How to update Identity Column in SQL Server?
  12. SQL query to split column data into rows
  13. Common Table Expression, why semicolon?
  14. T-SQL split string based on delimiter
  15. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  16. Splitting delimited values in a SQL column into multiple rows
  17. Compare DATETIME and DATE ignoring time portion
  18. Split function in SQL Server 2008
  19. SQL “between” not inclusive
  20. Can I set ignore_dup_key on for a primary key?
  21. Using PIVOT in SQL Server 2008
  22. Stored procedure that exports data into csv files only exports to one file
  23. How do I prevent a database trigger from recursing?
  24. How can I group by date time column without taking time into consideration
  25. How to combine results of two queries into a single dataset
  26. When using GETDATE() in many places, is it better to use a variable?
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. SQL take just the numeric values from a varchar
  29. COALESCE Function in TSQL
  30. Using CASE Statement inside IN Clause

Leave a Comment