Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8768 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / saraswathi muthuraman
Function :
1) Must return a single value. Only one value can be return
from a function.
2) Can be called from a sql(insert,update,delete) or
assignment st.U can't execute the function directly.
3) Can have DML,DDL,TLC inside function. But those function
can not be called from a sql.
Procedure :
1) Procedure can return multiple values.Procedure is
optional to return a value.
2) Can be executed directly and u can't called procedure
from sql.
3)Can have DML,DDL,TLC inside Procedure.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What happens if null values are involved in boolean operations?
What are the differences between clustered and non-clustered index?
What is cursors?
What were the latest updates to SQL Azure service?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What are the different types of subquery?
What do you mean by recursive stored procedure?
What is the use of nvl work?
What is the purpose of the model database?
What is global temp table?
List out different types of normalizations in sql server and explain each of them?
What are the different authentication modes in sql server? How can it be changed?
How is sql server used?
Do you know what are acid properties?
Explain the phases a transaction has to undergo?
