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

Assignment Help:

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.


Related Discussions:- Difference in stored procedure and user defined function

Create a windows application which contain display area, Requirements: ...

Requirements: 1.  Complete the following two exercises by developing working csharp projects. 2.  Write a report to explain csharp code written in the projects. 3.  Submi

What is sql cache dependency?, The SQL cache dependencies is a new characte...

The SQL cache dependencies is a new characteristic in ASP.NET 2.0 which can automatically invalidate a cached data object (like a Dataset) when the related data is modified in the

How many types of assemblies are, How many types of assemblies are there? ...

How many types of assemblies are there? Private, Public/Shared, Satellite. A private assembly is normally used by a one application, and is stored in the application's director

Urgently wanted a web developer, URGENTLY WANTED a Web Developer (with soli...

URGENTLY WANTED a Web Developer (with solid .NET skills) We are immediately in search of a creative passionate and highly organised expert Web Developer to join our team to work

Develop targin protocol, Develop Targin protocol Project Description: ...

Develop Targin protocol Project Description: We need to construct services in C# or VB.NET that will manipulate with a Targin TIP Protocol Server (protocol for financial info

Different types of jit, JIT compiler is the part of the runtime execution e...

JIT compiler is the part of the runtime execution environment. In Microsoft .NET there are three types  of JIT compilers are available: 1) Pre-JIT :- The Pre-JIT compiles the co

Difference between system exceptions and application excepti, What is the d...

What is the difference between System exceptions and Application exceptions? All exception is derived from Exception Base class. Exceptions are generated programmatically or ca

A few changes to outloproject description, A few changes to OutloProject De...

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

Bug correction and prediction, Bug Correction and Prediction Project Des...

Bug Correction and Prediction Project Description: The project is about the prediction of bugs and resolves the bug in the sample program using costriage algorithm. You have

Finding the frequencies - c# program, Finding the frequencies - C# Program:...

Finding the frequencies - C# Program: Please let me know how to find Frequencies in C#.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd