Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is difference between after and before?
What are the export options of ssrs?
What are distinctive joins find as a part of sql?
You want to use a perspective in an mdx query. How do you select the perspective?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What is primary key and example?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is log ldf?
Does full backup break log chain?
What are the 3 types of schema?
What is dbcc updateusage?
New concepts of sql server 2005 use in your project.
Should you normalize audio?
How to execute function in stored procedure sql server?
