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
How will you find out if there are expensive SQL statements running or not?
How data can be copied from one table to another table?
What is difference between delete & truncate commands?
How you can find out if an index is useful to the optimizer?
Where the sql logs gets stored?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is exclusive locks?
Is mysql better than sql server?
How to check table values in sql server?
How to create a Master database in SQL server ?
What are the difference between “where” and “having” clause in sql server?
How to rebuild indexes with alter index ... Rebuild?
What is temporal data type?
How do you delete duplicate records in sql server?
How to query multiple tables jointly?