What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / arvind kumar
there main difference:::
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 ? | 13 Yes | 2 No |
Post New Answer View All Answers
Is it safe to delete log files?
What is the purpose of object explorer and its features? : sql server management studio
what is an index? : Sql server database administration
What is #table in sql server?
What are rest-style architecture's?
Distinguish between nested subquery and correlated subquery?
How to set a database state to offline in ms sql server?
How do I completely remove sql server instance?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is the default server name for sql server?
What is difference between clustered and non clustered index?
How do I edit a stored procedure in sql server?
What methods do you follow to protect from sql injection attack?
What is merge statement?
What is snapshot parameter in ssrs?