Difference between Function and Procedure-in general?
- 6 Answers
- 13762 Views
- I also Faced
- E-Mail Answers
Answer Posted / dharmendra nonia
Function and Stored Procedure both are precompiled objects
in databases but there is some difference between UDFs and
Stored Procedure such as--
1)Function Must be return at least one value but stored
procedure may or may not.
2)We can use Function for only data manipulation but stored
Procedure is used to Manipulation as well as Modification
of Data on tables.
3)We can't use DML statements inside Function but In stored
Procedure, we can use DML statements.
4)In stored Procedure, we can pass INPUT and OUTPUT
parameter but Function accept only input parameter and
return a value.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What are the types of table?
What does top operator do?
Detail about query optimizer?
To which devices can a backup be created and where should these devices be located? : sql server management studio
Can multiple columns be used in sql group by clause in ms sql server?
Explain external key management in sql server 2008
Name three of the features managed by the surface area configuration tool? : sql server security
What is the difference between insensitive and scroll cursor?
What is data compression? : sql server database administration
How you would rewrite the sql query to return the customerid sorted numerically?
Why do we need normalization?
What is the tcp/ip port on which sql server runs?
Do you know what is xpath?
Indexes are updated automatically is the full-text index also updated automatically?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
