What is the difference between a Stored procedure and function?
- 9 Answers
- 11122 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
Explain the significance of routing? : asp.net mvc
Explain difference between friend and protected friend?
How may clustered index we can create in table?
Differentiate between early binding and late binding.
in which protocol ASP.NET WEB API Work?
What is difference cookie and session?
What are the Types of objects in ASP
How u refer webservices?
What parameters can you pass in the url of the api?
What is the differences between a primary key and a unique key in sql server?
Is it possible to write code in many languages in one asp.net project?
What is the purpose of App_Code folder in ASP.NET? Why we this?
How to Separate background image and front image from original picture....
hi .net gurus. plz if any one has dumps on 70-631 and 70-541 on windows sharepoint services kindly mail me.
Explain what is an assembly?
