What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106101 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
What is a unique key constraint?
What are filegroups in sql server?
What is the sql case statement used for? Explain with an example?
What do you understand by a view? What does the with check option clause for a view do?
How to drop existing views from a database in ms sql server?
What is federation member?
What is single-user mode?
Can you use order by when defining a view?
How do I open a .db file?
how would you troubleshoot blocking? : Sql server database administration
Can we use where clause in union?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is a join in sql?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Explain the different types of joins?
