Differences between functions and stored procedures?
Answer Posted / avinash
1. Functions can used with Select statement
SP are not
2. If we have a syntax error or bug in SP it ignore it at
execution. In case of Function it won't.
3. Function should return atlease one value.
SP may or maynot return values.
4. Function cannot include in other function.
We can execute one SP in other.
Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
Can you explain what is the use of custom fields in report?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What does the automatic recovery do?
What are the system database in sql server 2008?
How to change server name in sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Does partitioning ssd reduce performance?
What is normalization and what are the advantages of it?
Explain what you mean by 3 tier architecture.
How to find Duplicate Records In table?
Explain an automatic checkpoint
How to create a trigger for insert only?
Explain the various types of concurrency problem?
What are the advantages of using stored procedures?
What is snapshot report?