Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 113696 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / vijayabhaskarreddy
there are 3 main differences between sp and function.
1 sp takes input,output parameters, function takes only
input parameters.
2 temparary variables required to store return values of
sp. in functions temparary variables will be optinale.
3 sp can not be called directly into DML statements ,
functions can be called directly into DML statements.
| Is This Answer Correct ? | 64 Yes | 19 No |
Post New Answer View All Answers
What are group functions in query statements in ms sql server?
Give me a SQL Query to find out the second largest company?
Determine when to use stored procedure to complete sql server tasks?
Why olap is used?
Does a sql server 2005 select statement require a from?
How do I connect to sql server database?
What new changes are being made in SQL Server?
What is a full text index?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is use of @@ spid in sql server?
What are parameterized reports? What are cascading parameters in ssrs reports?
What are the difference between clustered and a non-clustered index?
Do you know how to make remote connection in database?
What is the maximum size of sql server database?
Why do we need normalization?
