What is the difference between a Stored procedure and function?

Answer Posted / orknob ghosh

Stored procs can't be called within function but function
can be called within stored procedures.

Stored proc can have DML statements whereas a fuction can't

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways are there to maintain a state in .net? What is view state?

588


Can more than one person use the same login?

570


Can asp.net work on an nt server?

553


What is Pre-Render event in ASP.NET?

588


What is a session in asp.net?

532






What is preprocessor in .net and type, where it use?

656


Explain server control extensibility with reference to asp.net 2.0 ?

537


What is the difference between page-level caching and fragment caching?

527


Why do we need asp.net?

588


Where can I get the details on migration of existing projects using various technologies to asp.net?

518


About CLR, reflection and assemblies?

1539


How does the service stream content?

584


How to handle errors in Web API?

624


What is a user developed application?

523


If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?

1969