SQL Server Stored Procedure - How To

[@DatabaseStar]

Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: www.databasestar.com/get-sql-cheat-sheets/?

[@colourNika]

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

[@DatabaseStar]

Thanks!

[@jerrychan1471]

Very clear examples, thanks for the video! You provided the exact info what I was looking for!

[@DatabaseStar]

Glad it was helpful!

[@JohnsonAdebayo-y7b]

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

[@DatabaseStar]

Thanks! You can use techniques such as if statements or case statements inside the stored procedures to validate the parameters

[@eromoselealbert6913]

This video is very helpful. Thanks for sharing this.

[@DatabaseStar]

Glad you like it!

[@Impergator-ld5gi]

Good structured Video and informative content 💪

[@DatabaseStar]

Glad you liked it!

[@gunthersantos]

thanks that was a really good explanation!!😉

[@DatabaseStar]

You’re welcome!

[@mezomezo8718]

Very well explained

[@DatabaseStar]

Thanks!

[@ryandx-v9j]

Concise, thanks :)

[@DatabaseStar]

You’re welcome!

[@kimleng539]

❤

[@DatabaseStar]

Thanks!

[@anujamahagamage1316]

🥰🥰

[@DatabaseStar]

Thanks!

[@kvelez]

CREATE PROCEDURE SelectCustomers
AS
SELECT *
FROM Customer;
=====
CREATE PROCEDURE InsertCustomer
@customer_name NVARCHAR (50), @customer_status INT=1
AS
INSERT INTO Customer
VALUES (@customer_name, @customer_status);
=====
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;

[@DatabaseStar]

Is there a question you have about this code?

[@kvelez]

@@DatabaseStar I wanted to share it with others so that they can use it.
**But if you can do a followup on procedures, I would enjoy it.