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
Import Columns of Data into Data Table for Data Grid View in C# and WPF Need help with a project in C# / WPF. Trying to read a csv file or text file with columns of data that wi

What is DTD? The Document Type definition (DTD) defines how your XML should structure. For illustrate in the above XML we want to make it compulsory to provide "qty" and "total

I need deatch-bycahpca API tutorial Please teach me how to use deatch-bycahpa API Skills required: Visual Basic, C# Programming

finding greatest of n no''s in c#

Sorting 2 Arrays & Merging into 1 - C# Program Hello, i didn't find the correct way to implement Array in my project. I am beginner for this language.  Please suggest me some

Site minder Authentication in SharePoint We have fit site minder agent in SharePoint 2010. We would like to have incorporate with site minder agent. Currently site-minder age

Project Description: We want to design and develop a new Sportbook Platform from scratch, subsequent functionality: - Have a full functionality like other similar websites (S

Checking for validity of an expression - C# Program Hello can you please provide me some examples regarding to the Checking for validity of an   expression in C#.

Explain the diffrent type of literals in c# The different types of literals in C# are: Boolean literals - Refers to the True and False literals that map to the true and fals

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