Interested to Buy Any Domain ? << Click Here >> for more details...
difference between function and procedure
- 3 Answers
- 5215 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
How to insert multiple rows with one insert statement in ms sql server?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What does it mean to be in union?
What happens if you delete a table that is used by a view?
How to declare and use cursor variables?
What is the difference between mysql and mysqli?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How each E-R model constructs can be mapped to the relational model?
What are the different authentication modes in sql server? How can it be changed?
How can you hide the sql server instances?
How do you delete duplicate records in sql server?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is a heap?
Do you know what is sql injection?
