Up:: Programming

Create stored procedure in MS Sql

• Language:: T-SQL

• Type:: Database

• Context:: creating stored procedures in MS Sql

• Description

• Snippet – the actual snippet/boilerplate (wrapped in code tags)

USE [database];  
GO  
CREATE PROCEDURE [ProcedureName]  
    @variable1 nvarchar(50) = null,   
    @variable2 int = null
AS   

    SET NOCOUNT ON;  
    
	[Query to be used, be in insert, update, delete or select];  
GO

• Dependencies:: Create a Stored Procedure - SQL Server | Microsoft Learn

---

📇Additional Metadata

• 📁Type::#type/snippet
• 🏷️Tags::
• 📡Status::#status/🌲