What is the difference between a Stored procedure and function?

Answer Posted / janardan baghla

1.stored proceudures can not return tables whereas
functions can.
2.stored procedures can not used in select statemnet
whereas functions can.

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between response.redirect and server.transfer?

754


Explain why it is useful to use mvc instead of webforms? : asp.net mvc

800


Just by seeing the signature of the bean how can you specify whether it is a stateful or stateless session bean?

735


Does asp.net still recognize the global.asa file?

728


How do u optimize a query in asp.net?

753


What are the options in ASP.NET to maintain state?

815


What is caching? Explain.

728


What are the modes of updation in an updatepanel? What are triggers of an updatepanel?

703


Can we store object in viewstate?

738


Can you explain how ASP.NET application life cycle and page life cycle events fire?

779


What is difference between View State and Hidden Field in ASP.NET?

847


What is the flow of processing of the request? : asp.net mvc

729


Explain what benefit does your code receive if you decorate it with attributes demanding specific security permissions?

739


Define satellite assemblies.

766


What is the life-span of the items in the viewstate?

708