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:: snippet
• 🏷️Tags::
• 📡Status:: #status/🌲