Answer Posted / srinivas k
Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.
| Is This Answer Correct ? | 5 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 is trigger explain with program?
Is it possible to update the views? If yes, how, if not, why?
What are orphan records?
What is PROJECTION Operation?
Tell me what is difference between view and materialized view?
How to rename an existing column with sql server management studio?
What is co-related sub query?
What is temporal data type?
Explain about system database?
What is query parameter in ssrs?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
How can sql server instances be hidden? : sql server security
What is TDS(Tabular Data Stream) Gateway?
Explain syntax for viewing trigger?