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

How would you go about developing a ssrs report?

135


What sql server means?

740


What is an example of a foreign key?

699


What is the rdl file?

100


What are the different authentication modes in sql server? How can it be changed?

774






How to find the service pack installed? : sql server database administration

774


What is mssql?

723


How to delete multiple rows with one delete statement in ms sql server?

693


What are the Advantages of using CTE in sql server?

769


What is meant by indexing files?

778


What is sql profiler. What are the default templates with it? : sql server database administration

693


What are the benefits and tasks of object explorer? : sql server management studio

802


Explain hostprotectionattribute in sql server 2005?

787


Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

810


What do we have to check in database testing?

769