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
- 112124 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
Differentiate between ms sql server reporting services vs crystal reports?
Explain the steps needed to create a scheduled job?
Why are views required in the sql server or in any other database?
How to turn on the mssql api module in php?
What is the difference between ddl and dml?
What is a bit datatype?
Does a specific recovery model need to be used for a replicated database? : sql server replication
What are the benefits and tasks of object explorer? : sql server management studio
What is a covering index?
Explain the difference between control flow and data flow?
What is 5nf in normalization form?
How to recompile stored procedure at run time?
Characterize join and name diverse sorts of joins?
Explain iaas, paas and saas?
Explain filtered indexes benefits?
