difference between function and procedure
- 3 Answers
- 4675 Views
- Cognizant, HCL, TCS, Theorem, I also Faced
- E-Mail Answers
Answer Posted / ramya
1.a function must returns a value where as procedure may not return value
2.a procedure can have parameters of both i/p and o/p but
fun has only i/p parameters
3.in procedure we can perform all the dml operations but in function only select operation should be performed
4.we call a procedure by using 'exec' or 'execute' command where as function is called by using 'select' command
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is stored procedures?
What is explicit cursors?
Explain indexes disadvantages?
What is the user of Primary key?
Explain how you can configure a running aggregate in SSRS?
How to override dml statements with triggers?
Explain for xml explicit mode?
How to enable/disable indexes?
How do you know if sql server is running on your local system?
How to count groups returned with the group by clause in ms sql server?
What do you mean by stored techniques? How would we use it?
How do I find sql server instance name?
What is the significance of null value and why should we avoid permitting null values?
How can you find out how many rows returned in a cursor?
What are the different subsets of sql?
