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

Mention what are the different types of ssrs reports?

128


What are the database objects? : SQL Server Architecture

754


Will the writetext statement activate a trigger?

783


Why use sub query in sql server and list out types of sub queries?

764


Do you know what is difference between stored procedure and user defined function?

852


query processing

1960


What is the command used to recompile the stored procedure at run time?

830


Explain sub-query?

770


How to return the date part only from a sql server datetime datatype?

820


Explain concepts of analysis services?

712


How to divide query output into multiple groups with the group by clause in ms sql server?

810


Do you know what is rank function?

855


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

773


What are the different methods available under sqlcommand class to access the data?

898


Explain log shipping?

813