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
Why we need sql server?
Give the query of getting last two records from the table in SQL SERVER?
What is difference between line feed ( ) and carriage return ( )?
What command would you use to create an index?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
How to apply cascading referential integrity in place of triggers?
How are the exceptions handled in sql server programming?
How to create new tables with "create table" statements in ms sql server?
What is analysis service repository?
Explain ranking functions?
Explain the difference between HTTP and HTTPS in database?
Explain can SSRS reports Cache results?
What is logon trigger?
Differentiate between truncate vs delete in mssql?
Explain the properties of a relational table?