thank you, simple explanation with straightforward examples ( I wish there were one advanced example)
@DatabaseStar Жыл бұрын
Thanks!
@Impergator-ld5gi Жыл бұрын
Good structured Video and informative content 💪
@DatabaseStar Жыл бұрын
Glad you liked it!
@user-zv8sb1en9x Жыл бұрын
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
@user-yw4jg9tz2l4 ай бұрын
Concise, thanks :)
@DatabaseStar4 ай бұрын
You’re welcome!
@mezomezo8718 Жыл бұрын
Very well explained
@DatabaseStar Жыл бұрын
Thanks!
@kimleng5394 ай бұрын
❤
@DatabaseStar4 ай бұрын
Thanks!
@anujamahagamage13163 ай бұрын
🥰🥰
@DatabaseStar3 ай бұрын
Thanks!
@kvelez2 ай бұрын
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;
@DatabaseStar2 ай бұрын
Is there a question you have about this code?
@kvelez2 ай бұрын
@@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.