MSSQL - Sotred Procedure Template

Use this template to create Stored Procedure:

-- EXEC USP_Test

USE DBName
GO

SET QUOTED_IDENTIFIER OFF
GO

IF OBJECT_ID('dbo.USP_Test') IS NULL EXEC('CREATE PROCEDURE dbo.USP_Test AS DUMMY:')
GO

GRANT EXECUTE ON USP_Test TO [Domain\UserName]
GO

ALTER PROCEDURE USP_Test
AS