difference between function and procedure
- 3 Answers
- 4439 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
Does a sql server 2005 select statement require a from?
Is there any difference between primary key and unique with the not null condition?
What are the types of subquery?
what is the difference between Delete and Truncate command in SQL
How to create new tables with "select ... Into" statements in ms sql server?
What is the openxml statement in sql server?
Where are stored procedures in sql server?
What is sql server profiler?
What are the different subsets of sql?
How do I find the size of a sql server database?
What is sql server database?
How you can change a cross join into an inner join?
What is a rollup clause?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is function of master database?
