Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Stored procedure and function?
- 9 Answers
- 13470 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhavi latha
stored procedute can return only one integer value.while
function can return more than one value.
we can not use select statement with storedprocedures like
select <spname> where as UDF can.
storedprocedures can not return tables.where as UDF can
return more than one tables.
we can use functions inside the stored procedure but in UDF
we can not use storedprocedures.
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
witch is the best insistute in sharpoint course.what abt future of share point course.
Explain the concept of MVC Scaffolding?
What are ASP.NET Web Forms? How is this technology different than what is available though ASP?
How to do parallel database export in remote SQL Server in ESSL time track. It is working for local server but not working for remote SQL Server
What is difference between session and cookie?
What are the merits and demerits of viewstate?
Explain difference betn dataset and recordset?
Which is better union or union all?
What is boxing and unboxing in asp.net?
What is session handling in a webfarm, how it can work with its limits?
How will create assesblies at run time?
What is http post and http get?
What’s the catch?
where can i gather the materials for MCP certification
What is asynchronous call?
