what is the difference between procedure and function.
Answer Posted / hitesh
1.Procedure can call a function but Function cannot call
the function.
2.Procedure may or may not return the value but function
must return a scalar value.
3.Procedure can have any statements and function can have
only select like thing
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What do you mean by sql server 2005 express management tools?
What stored by the model? : sql server database administration
How to convert numeric expression data types using the cast() function?
What are the acid properties?
How to create prepared statements using odbc_prepare()?
What is the log shipping?
Do you know what is fill factor and pad index?
How can sql server instances be hidden? : sql server security
How to get the query of a table in sql server?
What do you understand by recursive stored procedure?
How to rebuild indexes with alter index ... Rebuild?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
How column data types are determined in a view?
How to fine-tune reports?