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
- 112767 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
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
When to use null data driven subscription?
Which autogrowth database setting is good?
Explain the difference between cross join and full outer join?
What is difference statement and preparedstatement?
What is attribute? : sql server analysis services, ssas
How to list all stored procedures in the current database using ms sql server?
Why truncate is ddl?
Does group by sort data?
Why main is user defined function?
What are “lock” hints?
How to delete multiple rows with one delete statement in ms sql server?
What are views used for?
Explain sql server service broker?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
