Difference between Function and Stored Procedure?
- 9 Answers
- 19039 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / raj..
The difference mejor between procedure and function is that
function must return value. that should be only single and
function can pass any no. parameter but come out only one
value only using return statement.
procedure can pass any parameter and came out any no. of
values there no any RETURN word.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain user defined views?
Explain the steps to use transact-sql cursor?
What is a trace frag?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is SQL Azure Firewall?
Find first and last day of current month in sql server
What are the differences between ms sql server & oracle?
what are user defined datatypes and when you should go for them? : Sql server database administration
Why normalization is used?
What is a constant or literal in ms sql server?
What is the difference between stored procedure and functions?
What is enhanced database mirroring in sql server 2008?
what are isolation levels? : Sql server database administration
What is efficiency data?
What are the advantages of using a stored procedure?
