Difference in stored procedure and user defined function, DOT NET Programming

What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?

Some of major differences between a stored procedure and user defined are as follows:-

1.      The UDF can be executed by using the "SELECT" clause while SP's can not be.

2.      The UDF cannot be used in the XML FOR clause while the SP's can be used.

3.      The UDF does not return any output parameters while the SP's return output parameters.

4.      If there is an error in the UDF its stops executing. But in SP's it just ignores the error and moves to the next statement.

5.      The UDF cannot make permanent changes to the server environments while SP's can

6.      Change some of the server environment.

Posted Date: 9/24/2012 3:20:35 AM | Location : United States







Related Discussions:- Difference in stored procedure and user defined function, Assignment Help, Ask Question on Difference in stored procedure and user defined function, Get Answer, Expert's Help, Difference in stored procedure and user defined function Discussions

Write discussion on Difference in stored procedure and user defined function
Your posts are moderated
Related Questions
What is the main difference b/w MSML and .NET Framework XML classes? The MSXML supports XML DOM and SAX parsers while the .NET framework XML classes support XML DOM and XML rea

having trouble programming

Explain the difference between XML and HTML. XML explains data while HTML describes how the data should be displayed. Thus, HTML is about displaying information while XML is ab

A few changes to OutloProject Description: We require someone who is familiar with programming plug-in to work with Microsoft Outlook. Initially we just require a simple chan

I have a responsive database structure and web template. I need someone to prepare the code (.net, jquery ) to make interaction with database . Insert, edit , save . Plus a custom

Why isn''t there an allowed amount for nonfacility for code 27405?

I require a visual basic (VB) app developer to enhance an existing application. There are very few manual inputs in the application which I need to be imported via excel file. E

What is Common Type System (CTS)? CTS is the component of CLR by which .NET Framework provides support for multiple languages because it have a type system that is common acros

I need to create the subsequent iOS App/ iPhone (to be followed by Android & other platforms). Version 1.0--Users can: --Find events based on proximity/zipcode*/ location

Name the binders provided by .NET Framework 4.0. .NET Framework 4.0 provides the following binders: Object Binder - Enables to communicate with .NET objects. JavaScrip