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
Why do we use functions?
What is the difference between lock, block and deadlock? : sql server database administration
Explain features and concepts of analysis services?
What do you mean by an execution plan?
What is store procedure?
Do you know what is fill factor and pad index?
What is the cpu pressure?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What do you understand by triggers and mention the different types of it?
Do you know sql server 2008 introduces automatic auditing?
Can you tell me about the concept of ER diagrams?
Do you know hot add cpu in sql server 2008?
What is merge replication?
What is role playing dimension with two examples? : sql server analysis services, ssas
What are translations and its use? : sql server analysis services, ssas