SQL Server Stored Procedure - How To

[@DatabaseStar]

Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: databasestar.mykajabi.com/lpkj-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

[@Impergator-ld5gi]

Good structured Video and informative content 💪

[@DatabaseStar]

Glad you liked it!

[@eromoselealbert6913]

This video is very helpful. Thanks for sharing this.

[@DatabaseStar]

Glad you like 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.