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
Question: (a) Explain the Postback process as use with Web Forms. (b) Write extract codes to demonstrate how to store and retrieve values in: (i) a Session Object (ii)

What is "Common Language Runtime" (CLR)?  CLR is .NET equivalent of Java Virtual Machine (JVM). It is the runtime that changes a MSIL code into the host machine language code,

The Performance of the viewstate varies depending on the type of server control to which it is applied. The Text Box, Label,   RadioButton,CheckBox, and HyperLink are server contro

Encripter-Decripter application Project Description: I want an application which can encrypt - decrypt text, images, and music files as well as videos. Skills required are

What is a Interface? The Interface is a contract that describes the signature of the functionality. So when a class is implementing a interface it says to the outer world, that

What are the  steps of acquiring a proxy object in Webservice? The following steps are required to get a proxy object of a webservice at the client side:- 1.     The Clie

Project Description: I require a C# Console project written to simply enter an Origin and Destination/Date on the United Airlines Site, from the returned page select and return

I need mt4 programmer Project Description: I'm seeking a professional programmer to teach me MQL I have few years experience in manual trading but totally NONE in MT4 / EA

What is difference between System.String and System.StringBuilder classes? String and StringBuilder classes are used to store string values but the dissimilarity in them is tha

What are methods? Methods are the building blocks of a class, in which they are linked together to share and process data to produce the result. In other words, a method is a b