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
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What are key constraints?
What is a trigger in sql server?
What is stored procedures?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Do you know what are different types of replication in sql server?
What is the ‘fillfactor’?
How retrieve field names from the table in SQL through JAVA code?
What are user-defined functions (udfs) in sql server?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is the difference between functions and stored procedures?
What do you mean by sql server 2005 express management tools?
What are indexes in ms sql server?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
Can we use where clause with group by?