Difference between Function and Procedure-in general?
Answer Posted / mona
Function can return at most one value at a time while
procedure can return more than one value at a time You can
use function within Sql Statement and you cannot use stored
procedure with in Sql Statement
Is This Answer Correct ? | 19 Yes | 11 No |
Post New Answer View All Answers
What is Command line parameters in PLSQL.?
What are the different types of backups avaialabe in sql server 2005?
what are user defined datatypes? : Sql server database administration
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is function of ROLLUP ?
How many replicas are maintained for each sql azure db?
What is resultset concur_updatable?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How can you find out how many rows returned in a cursor?
What is row_number()?
what is dbcc? : Sql server database administration
Can group by and orderby be used together?
How can a user-defined datatype be created?
What are the instances when triggers are appropriate?
Does a server store data?