answersLogoWhite

0

we cant use DML operations in functions where as it is possible in sp. Procedure can return zero or n values whereas function can return one value which is mandatory. error handling can be done in sp, but not possible in function. functions can be called from select statements, where clause and case but not possible in sp. Procedures can have input,output parameters for it whereas functions can have only input parameters Functions can be called from procedure whereas procedures cannot be called from function. We can go for transaction management in procedure whereas we can't go in function.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

Difference between a local procedure and stored procedure?

local procedure wont store in database. Stored procedure store in database permanently and we can use it whenever we require. Other program also can use this stored procedure. And the transaction of stored procedure take care by DBA. But the local procedure transaction is take care by manually only


What is the difference between a stored database procedure and a batch of SQL statements submitted by a client application?

Stored procedures prevent unauthorized access to data


Is it possible to call a stored procedure from java script function and populate an aspnet dropdown list HTML control using the value returned by the SP?

No, a stored procedure can not be called from Javascript. A dropdown list however can be populated using a stored procedure.


Where static variables stored?

they are stored in the memory.they obviously can't be stored in stack Bcoz there value won't be retained between function call.


What is the difference in English Language between a wardrobe and a cupboard?

Clothing is stored in a wardrobe. Dishes are stored in a cupboard.


Can You Write Trigger in Stored Procedures?

A trigger is a stored procedure. It is a special stored procedure that runs in response to some defined event, such as an insert into a table.


How to draw E-R diagram for library management system?

how to draw the er diagram of library management system


What is the relationship between the potential difference across a capacitor and the amount of charge stored on it?

The potential difference across a capacitor is directly proportional to the amount of charge stored on it. This means that as the potential difference increases, the amount of charge stored on the capacitor also increases.


What is the meaning of the term stored procedure?

A stored procedure is considered a subroutine, which is considered to be only available to the applications with access to a relational database system.


Suppose a parallel plate capacitor (with capacitance) is connected to a battery, what is the relationship between the charge stored on the capacitor and the potential difference across its plates?

The relationship between the charge stored on a capacitor and the potential difference across its plates is that the charge stored on the capacitor is directly proportional to the potential difference across its plates. This relationship is described by the formula Q CV, where Q is the charge stored on the capacitor, C is the capacitance of the capacitor, and V is the potential difference across the plates.


What is the difference between stored procedure and index?

As stored procedure in procedural code, which usually calculates or changes some data. An index is a database object which aids in quick location of records because it is internally ordered in a optimized way for the specific key


What is the difference between struct and union in c file management?

The main difference is in how the data structures are stored. In a union, all of the elements are stored in one location. A structure stores each of its elements in a separate memory location.