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