What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106166 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
If the job running very slow what is the action you do
Explain raiserror in sql server?
What is repeatable read?
What does it mean to be in union?
Which data type columns are the best candidates for full-text indexing?
Explain the steps needed to create a scheduled job?
Is mysql the same as sql server?
How to update values in a table with update statements in ms sql server?
How do I find the default sql server instance?
Please explain what is “asynchronous” communication in sql server service broker?
How can we delete Duplicate row in table?
What is the difference between sdf and mdf?
Explain about system database?
Why do we partition data?
How to list all tables in the database using odbc_tables()?
