Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8806 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 are trace files?
Does transparent data encryption provide encryption when transmitting data across the network?
Please differentiate between a local and a global temporary table?
Do you know what are acid properties?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Can group by be used without aggregate functions?
Explain trigger and its types?
Can we create clustered index on composite key?
What is msdb database? : SQL Server Architecture
How secure is sql server database?
Explain the disadvantages of cursors?
What is row_number function?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Explain SSRS Architecture?
Give a example to search fr a string in all stored procedure in sql server.
