SQL Server Stored Procedure - How To

Stored procedures are a helpful feature of SQL Server.
In this video, you'll learn:
- what they are
- when and why to use them
- some simple examples of using stored procedures to select, insert, update, and delete data

⏱ TIMESTAMPS:
00:00 - Intro and setup
01:08 - Select stored procedure
03:04 - Insert stored procedure
06:41 - Update stored procedure
08:26 - Delete stored procedure

🔗 VIDEO LINKS:

[colourNika]

thank you, simple explanation with straightforward examples ( I wish there were one advanced example)

[zvsbenx]

Well done on this video, please I need your tutorial on how to use the Stored procedure for the validation of input parameters

[Impergator-ldgi]

Good structured Video and informative content 💪

[kvelez]

CREATE PROCEDURE SelectCustomers
AS
SELECT *
FROM Customer;



CREATE PROCEDURE InsertCustomer
@customer_name NVARCHAR (50), @customer_status INT=1
AS
INSERT INTO Customer




CREATE PROCEDURE UpdateCustomer
@newName NVARCHAR (50), @newActive INT, @customerId INT
AS
UPDATE Customer
SET Name = @newName,
is_active = @newActive
WHERE Id = @customerId;

====

CREATE PROCEDURE DeleteCustomer
@customerId INT
AS
DELETE Customer
WHERE Id = @customerId;