Difference between Function and Stored Procedure?
- 9 Answers
- 18972 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
How many categories of functions based their return modes?
What is database white box testing?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How do you implement session management in SQL Server mode?
In what version of sql server were synonyms released?
How can you set the threshold at which sql server will generate keysets asynchronously?
Why Master database is required?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What are the different types of upgrades that can be performed in sql server?
what is a transaction and what are acid properties? : Sql server database administration
What is attribute hierarchy? : sql server analysis services, ssas
How to Check if table exists in sql server?
Can sql servers linked to other servers like oracle?
How to defragment table indexes?
