Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8577 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
How many types of cursor type are there?
How does a profiler work?
What is dml command?
What is row_number function?
Explain the Ways to improve the performance of a sql azure database?
Why use cursor in sql server?
What is subquery explain with example?
How to round a numeric value to a specific precision?
How can we check the sql server version?
How to use column default values in insert statements in ms sql server?
Why use update_statistics command in sql server?
How to stop a loop early with break statements in ms sql server?
What are the difference between primary key and unique key? : sql server database administration
What is a bit datatype?
What is data mart? : sql server analysis services, ssas
