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
- 112845 Views
- College School Exams Tests, HCL, Infosys, TCS, I also Faced
- E-Mail Answers
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
How to modify an existing user defined function?
Distinguish between commit and rollback?
How to run sql server 2005 books online on your local system?
How to attach adventureworkslt physical files to the server?
Why is sql server log file full?
What is an example of a primary key?
Where can you find the error log information? : sql server database administration
List out the differences between the clustered index and non-clustered index in sql server?
What is the difference between Clustered and Non-Clustered Index?
Which language rdl files made of?
What is BCNF? How is it better than 2NF & 3NF?
Tell me about builtinadministrator?
How to call stored procedure using http soap?
what are isolation levels? : Sql server database administration
How to convert binary strings into integers in ms sql server?
