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