Interested to Buy Any Domain ? << Click Here >> for more details...
What are the blocks in stored procedure?
- 6 Answers
- 15020 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 would you convert date into julian date format?
Is nosql relational?
What is dba in sql? : SQL DBA
Why query optimization is needed?
What is record in pl sql?
How are sql commands classified?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is rank dense_rank and partition in sql?
What is a boolean in sql?
What is a natural join sql?
Why is pl sql used?
Explain the difference between 'between' & 'and' operators in sql
how to install mysql? : Sql dba
What is the importance of sqlcode and sqlerrm?
Explain the uses of a database trigger?
