Answer Posted / sakthi
Inside function we cannot able to insert, udate or delete
any record but in procedure we can use it. inside function
we cannot able to call any other functions or procedure but
inside procedure we can call other procedure and functions.
these are the major differences
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to copy data from one table to another table?
how you can configure a running aggregate in SSRS?
How to stop a loop early with break statements in ms sql server?
Explain different types of collation sensitivity?
What is service broker? : sql server database administration
can an automatic recovery be initiated by a user? : Sql server administration
Explain active/passive and active/active cluster configurations?
Write SQL queries on Self Join and Inner Join.
Which are the olap features?
What are different types of statements that are supported by sql?
What is cube dimension? : sql server analysis services, ssas
What are audit control procedures?
What do you understand by mirroring?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
How to create percentile function?