What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106174 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 ssrs?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
How to get a list of columns in a view using the "sp_columns" stored procedure?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What are the restrictions while creating batches in sql server?
What is attribute? : sql server analysis services, ssas
What is difference in performance between insert top (n) into table and using top with insert?
Can you index views?
What is a constant or literal in ms sql server?
What is the tcp/ip port on which sql server runs?
what is a self join? Explain it with an example? : Sql server database administration
Where are sql server user names and passwords stored in sql server?
Why the trigger fires multiple times in single login?
What are trace flags and mention a few common trace flags used with sql server?
How to delete an existing database user?
