mikaelweave · January 22, 2016 22:25
diff --git a/blank_stored_procedure_template.sql b/blank_stored_procedure_template.sql
 IF OBJECT_ID('MySproc', 'P') IS NOT NULL
 DROP PROC MySproc
 GO

 CREATE PROC MySproc
 AS
 BEGIN
 	[CODE HERE]
 END
diff --git a/blank_table_template.sql b/blank_table_template.sql
 USE database;
 GO

 IF OBJECT_ID('dbo.mySproc', 'U') IS NOT NULL DROP TABLE dbo.mySproc;
 CREATE TABLE dbo.mySproc
 (
  [columns here]
 );
	IF OBJECT_ID('MySproc', 'P') IS NOT NULL
	DROP PROC MySproc
	GO

	CREATE PROC MySproc
	AS
	BEGIN
	[CODE HERE]
	END
	USE database;
	GO

	IF OBJECT_ID('dbo.mySproc', 'U') IS NOT NULL DROP TABLE dbo.mySproc;
	CREATE TABLE dbo.mySproc
	(
	[columns here]
	);