Cacher is the code snippet organizer for pro developers

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