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
Equi join and non equi join is possible with sql server?
How to remove duplicate rows from table except one?
Can we do dml on views?
What is the primary use of the model database?
How do I find query history in sql server?
List the ways in which dynamic sql can be executed?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is sql server query analyzer?
What is the difference between for xml raw and for xml auto?
What is a view in sql?
What is in place upgrade in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Disadvantages of the indexes?
How can you append an identity column to a temporary table?
What kind of problems occurs if we do not implement proper locking strategy?
