Answer Posted / jayanth
Functions always returns a value where as sp performs bath execution
functions can be used along with select statement and where clause where as functions cannot be used with update insert delete statements in which sp cannot be used with select and DML events
functions cannot be used with try catch block where as sp can use try catch block
functions are of two types system functions and user defined functions where as sp's are four types mostly
sp with parameters
sp without parameters
sp with out parameters
sp with return values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to filter out duplications in the returning rows in ms sql server?
How can you tell if a database object is invalid?
How can you control the amount of free space in your index pages?
How is foreign key related to primary key?
What will be query used to get the list of triggers in a database?
what are the new features introduced in sql server 2000? : Sql server database administration
What is the difference between a fill factor of 100 and 0?
When you should use a low fill factor?
Why do we need different type of parameter?
What is policy management?
What function does a database engine serve in the sql server?
Explain insert into select statement?
what is the sql equivaent of the dataset relation object ?
How to use column default values in insert statements in ms sql server?
What is pivot and unpivot?