Differences between functions and stored procedures?
- 8 Answers
- 13100 Views
- 247Customer, Accenture, I also Faced
- E-Mail Answers
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
What is the user of Primary key?
Can a table have 2 primary keys?
What is multi-statement table-value user-defined function?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Explain the collation?
What do you think of this implementation? Can this be implemented better?
What is the difference between varchar and varchar types?
Can we perform backup restore operation on tempdb?
What are transactions in sql?
What does it mean to normalize a database and why would you do it?
How optimize sql query with multiple joins in sql server?
how many type of indexing in database?
how to invoke a trigger on demand? : Sql server database administration
What is lock escalation? : sql server database administration
