What are the differences between stored procedure and
functions in SQL Server 2000?
- 25 Answers
- 106269 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
What is difference between standardization and normalization?
How we can compare two database data?
How many types of triggers are there?
Can foreign key be deleted?
Why do we use functions?
What is the default fill factor value?
When is update_statistics command used?
Why should you use or avoid select * statements?
Do you know what is lock escalation?
Can we write a distributed query and get some data which is located on other server and oracle database?
Which are ddl commands?
Which are the new data types introduced in sql server 2008?
What is a dbms wizard?
What is 4nf in normalization form?
What is the stuff and how does it differ from the replace function?
