Month: July 2023

Stored Procedure Template

Normally I adopt the local standard, but failing that here is my current Stored Procedure template suitable for all cloud environments. This year I have gone ultra simple 🙂

-- NewProcName.sql

USE [SomeDbName];
GO

/* =====================================
   Author:		Richard
   Date:		10 Jul 2023
   Description: What it should do
   ===================================== */

CREATE PROCEDURE [schema].[NewProcName]
AS
BEGIN
    SET XACT_ABORT, NOCOUNT ON;

		/* Do things */

END
GO