Interested to Buy Any Domain ? << Click Here >> for more details...
What are the blocks in stored procedure?
- 6 Answers
- 15322 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
what is the stuff function and how does it differ from the replace function? : Sql dba
What is delimiter sql?
Does oracle roll back the transaction on an error?
Is a foreign key always unique?
What are stored procedures in mysql?
What is a sql instance vs database?
what is log shipping? : Sql dba
What is the requirement of self-join?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
what is the difference between truncate and delete statement? : Transact sql
How do I find sql profiler?
Explain what is a subquery ?
What is varchar example?
what is collation? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
