.Net Framework, Asp.net, Ado.net, .Net Remoting, .Net Webservice, SQL, XML, XSLT, WCF, WPF, WWF NHibernate, Ajax, Jquery, DHTML

Ado.netAsp.Net 2.0SQLC-SharpXMLFrameworkIISXMLWebServiceArchitecture
UMLProject ManagementSDLCMethodologiesDesign PatterenOOPWCF.Net RemotingWWF
MVPMVCSilver LightN-HibernateAjaxJ-QuerySEO-MarketingSite MapPhp

ETG Consultancy
Home
Consultancy
Portfolio
Join Us
Contact Us
Advertisement
Articles
WCF
User Control
Custom Control
Reflection
Deligate
UML
Globilisation
Threading
LINQ
Performance Tips
Interviews

Difference between store procedure and function

TransactionXML bulk Insertion into SQL Server
SQL JoinsCursor
Isolation Level Difference in procedure & function
Indexing in SQL SSIS - DTS
Union
Alter in Sql


Procedures Functions
1. Procedures can have input,output parameters Functions can have only input parameters
2. Procedures cannot be called from function Functions can be called from procedure
3. Exception can be handled by try-catch block in a procedure Try-catch block cannot be used in a function.
4. Transaction management can be done in procedure Cant write transaction in a function.
5. Procedure may or may not return a value Function will alaways returns a value
Leave your comment.
Name
Email
Comments
Tell Us1529+5 =

Reduce your Dialy IT Cost, Consult with us
Stay healthy in recession

Advertisement
Sponsored by

Privacy Policy ©2009 ETG Consultancy, All Rights Reserved Terms & Conditions
Asp.net, Ado.net, .Net Remoting, .Net Webservice, SQL, XML, XSLT, WCF, WPF, WWF NHibernate, Ajax, Jquery, DHTML