SQL script with comments

SQL

Download (.zip)

USE PUBS
GO

SELECT * FROM authors
/*
GO
SELECT * FROM sales
GO
SELECT * FROM publishers
GO
*/
SELECT * FROM titles
GO

SQLCorrelated subquery with derived table JOINs with dummy rows Problems with old style outer JOINs
SQLReuse of plans with sp_executesql script with comments Update in serializable mode with index