Select from following answers:- True

- False
- Maybe
- All Above
True, here's an example to depict the fact:-
Create Procedure usp_delete_customer
@cust_id int
AS
BEGIN
delete from tbl_customer
where cust_id = @cust_id
END
Here:-
(1) usp_delete_customer is the name of the stored procedure.
(2) @cust_id int is the parameter which is optional
(3) Inside the BEGIN and END tag is the body of the procedure
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator