Interested to Buy Any Domain ? << Click Here >> for more details...
What are the blocks in stored procedure?
- 6 Answers
- 15541 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / pronobesh
Actually there are 3 blocks
1) Declartion Block - Starts with AS right after CREATE
PROCEDURE <Proc Name>
2) Execution Block - Starts with BEGIN and ends with END
ahere the actual execution happen.
3) Exception Block - Where we catch the procedure error.
Hope this clarifies.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to add, remove, modify users using sql?
What is a natural join?
how to use regular expression in pattern match conditions? : Sql dba
i have some prob lem to tell me about my self in interview first round ...
what is a database? : Sql dba
How does pl sql work?
What are % type and % rowtype?
Define union, minus, union all, intersect ?
Is it possible to pass parameters to triggers?
What is set transaction?
What is sql*loader?
what is a constraint? : Sql dba
How do you delete a table?
Where not exists in sql?
what is the difference between sql and t-sql? : Transact sql
