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
How many types of schemas are there?
What will be the maximum number of indexes per table?
What does indexation mean?
Do you know what is difference between index seek vs. Index scan?
What is collation sensitivity? Explain different types.
Explain “@@rowcount” and “@@error” in sql server?
what is the system function to get the current user's user id? : Sql server database administration
what is nonclustered index
How to execute multiple stored procedures at one time in sql server?
What happens if null values are involved in string operations?
How network traffic be reduced by using the stored procedure?
How to create a new login name in ms sql server?
what are the disadvantages of cursors? : Sql server database administration
What is rolap and its advantage? : sql server analysis services, ssas
what is create database syntax? : Sql server database administration