Interested to Buy Any Domain ? << Click Here >> for more details...
difference between function and procedure
- 3 Answers
- 5335 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
Why use triggers?
How do I get to sql server configuration manager?
what is a sub-report?
What are different replication agents and what's their purpose? : sql server replication
What are the different type of replication in sql server?
What is mean by dml?
Does sql server 2000 full-text search support clustering?
What is difference between Datepart() and Datename() in SqlServer?
Explain syntax for dropping triggers?
Can we perform backup restore operation on tempdb? : sql server database administration
What is a trigger? Why we need it?
What is index fragmentation in ms sql server?
How can you tell if a database object is invalid?
How to use subqueries with the exists operators in ms sql server?
Why would you use sql agent?
