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


Please Help Members By Posting Answers For Below Questions

What is Command line parameters in PLSQL.?

577


What are the different types of backups avaialabe in sql server 2005?

616


what are user defined datatypes? : Sql server database administration

511


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1395


What is function of ROLLUP ?

640






How many replicas are maintained for each sql azure db?

104


What is resultset concur_updatable?

576


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

541


How can you find out how many rows returned in a cursor?

547


What is row_number()?

572


what is dbcc? : Sql server database administration

512


Can group by and orderby be used together?

591


How can a user-defined datatype be created?

534


What are the instances when triggers are appropriate?

518


Does a server store data?

493