Answer Posted / srinivas k
Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain how to maintain a fill factor in existing indexes?
What is tcl in sql server?
What protocol does sql server use?
what is dbcc? : Sql server database administration
Do you know hot add cpu in sql server 2008?
What is user-defined inline table-valued function?
What is difference between joins and subqueries?
How do you improve the performance of a SQL Azure Database?
explain databases and sql server databases architecture? : Sql server database administration
What do we need queues in sql service broker?
What are 3 ways to get a count of the number of records in a table?
Can we perform backup restore operation on tempdb?
How to find the second highest salary of an employee?
What is the Difference Between Primary and Foreign Key?
Explain cdc and sql injection?