SQL Server: How to Create a Stored Procedure Using SQL Script
In this video we take a look at how to create a in SQL Server using SQL script within SQL Server Management Studio.
Links:-
(Microsoft SQL Server Management Studio: How To Download & Use For Free) • Microsoft SQL Server Management Studio: Ho...
(SQL Server: How To Create A Table Using SQL Script) • SQL Server: How To Create A Table Using SQ...
(SQL Server: How to Insert Data into a Table Using SQL Script) • SQL Server: How to Insert Data into a Tabl...
(SQL Server: How to Create a Function Using SQL Script) • SQL Server: How to Create a Function Using...
Script:-
DROP PROCEDURE IF EXISTS [dbo].[GetConfigs]
GO
CREATE PROCEDURE [dbo].[GetConfigs](@Key VARCHAR(64)) AS
BEGIN
SELECT c.* FROM [dbo].[Config] c WHERE c.[Key] LIKE @Key + '%'
END
GO
If you enjoyed the video don't forget to like, comment and subscribe. Thanks for watching.