Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8620 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 do I find the query plan in sql server?
Sql server reporting services vs. Crystal reports.
what are the types of indexes? : Sql server database administration
What are a database and a data warehouse?
If a stored procedure is taking a table data type, how it looks?
What is the sql server agent?
Would you store your query in a ssrs report or a database server? State the reason why?
How to use the inserted and deleted pseudo tables?
What is primary key and example?
What is compound operators?
What is the difference between the 2 operating modes of database mirroring?
Explain for xml explicit mode?
Explain what is the use of custom fields in report?
Can the query output be sorted by multiple columns in ms sql server?
What are “phantom rows”?
