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

Creating dynamic web pages, As you have probably realized by now, Web pages...

As you have probably realized by now, Web pages are much more useful when they are dynamic. In Internet terminology, the word dynamic means several things. Primarily, it refers to

Prepare an application in c# or c++, Prepare an Application in C# or C++ ...

Prepare an Application in C# or C++ Project Description: We are seeking someone who can write a program in C# or C++. The concept is to develop the program using a Cross P

For looops, 25 16 25 9 16 25 4 9 16 25 ...

25 16 25 9 16 25 4 9 16 25 1 4 9 16 25

What is data independence, What is Data Independence? Data independenc...

What is Data Independence? Data independence means that "the application is independent of the storage structure and access method of data". In other words, the ability to cha

Payroll managment, how can i construct er diagram for payroll managment

how can i construct er diagram for payroll managment

Backend solution up integrate it with the frontend, Project Description: ...

Project Description: System is used for tracking company's activities through several projects by keeping track of incomes and expenses per project. This project is fairly ea

I need chatting application, I need Beautiful Chatting Application Proje...

I need Beautiful Chatting Application Project Description: I need a beautiful chatting application created that has both private as well as public chat system. The chatting c

Cache callback, What is Cache Callback? The Cache object is dependent o...

What is Cache Callback? The Cache object is dependent on its dependencies for example time based, file based, etc...The Cache items remove the object when cache dependencies ch

Create and populate a checkboxlist control, Question: (a) The ObjectDa...

Question: (a) The ObjectDataSource control is an alternative design approach to using AccessDataSource or SqlDataSource controls. Explain and illustrate how an ObjectDataSourc

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