thank you, simple explanation with straightforward examples ( I wish there were one advanced example)
@DatabaseStar
Жыл бұрын
Thanks!
@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
@Impergator-ld5gi
Жыл бұрын
Good structured Video and informative content 💪
@DatabaseStar
Жыл бұрын
Glad you liked it!
@user-yw4jg9tz2l
4 ай бұрын
Concise, thanks :)
@DatabaseStar
4 ай бұрын
You’re welcome!
@mezomezo8718
Жыл бұрын
Very well explained
@DatabaseStar
Жыл бұрын
Thanks!
@kimleng539
4 ай бұрын
❤
@DatabaseStar
4 ай бұрын
Thanks!
@anujamahagamage1316
3 ай бұрын
🥰🥰
@DatabaseStar
3 ай бұрын
Thanks!
@kvelez
3 ай бұрын
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
3 ай бұрын
Is there a question you have about this code?
@kvelez
3 ай бұрын
@@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.
Пікірлер: 17