Template for a blank MS-SQL (T-SQL) stored procedure.

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

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]
);