Interested to Buy Any Domain ? << Click Here >> for more details...
difference between function and procedure
- 3 Answers
- 5506 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 do you understand by physical_only option in dbcc checkdb?
Explain use of expression builder.
What the difference between UNION and UNIONALL?
Which table keeps information about stored procedures?
How do I view views in sql server?
What happens if time-only values are provided as date and time literals?
how many type of indexing in database?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is the difference between varchar and nvarchar?
How can you find out which stored procedures are recompiling?
Explain “row_number()” in sql server with an example?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What are various limitations of the views?
What is the default sql server instance name?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
