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 many types of schemas are there?

761


What will be the maximum number of indexes per table?

732


What does indexation mean?

732


Do you know what is difference between index seek vs. Index scan?

712


What is collation sensitivity? Explain different types.

750


Explain “@@rowcount” and “@@error” in sql server?

760


what is the system function to get the current user's user id? : Sql server database administration

768


what is nonclustered index

712


How to execute multiple stored procedures at one time in sql server?

717


What happens if null values are involved in string operations?

755


How network traffic be reduced by using the stored procedure?

821


How to create a new login name in ms sql server?

733


what are the disadvantages of cursors? : Sql server database administration

722


What is rolap and its advantage? : sql server analysis services, ssas

976


what is create database syntax? : Sql server database administration

820