Answer / ashok

Main difference between sp and function is we cannot use
store procedure in select statement where as we can use
function in select statement.

Answer / suresh jayaraman

Procedure-is also called Proc

proc-parsing resloving organizing compiling

stored Procedure once compiled and run many times,when we
create procedure,that procedure is stored in executeplan,so
no need to recompile.

but fuction every time compiling and running.

Answer / ramesh

stored proc is a precompiled one.

Answer / suresh mandala

1>Stored Procedure returns morethan one value where as
Function returns only one value
2>stored procedure we may use return statement.. but in
userdefined function we should use return statement
3>stored procedure is precomplied but function compile each
time we call it.

If u have any quieries ask me ,i will try

Answer / shivendra pandey

stored procedure is precomplied and not return value by
default but function compile each time and use return
statement simply.
if u r using database then use stored procedure for
pefmance n if u are working with simple pl for some
calculation go for function

Answer / ramesh

stored procedure we may use return statement.. but in user
defined function we should use return statement

Answer / urvish

store procedure can return Output Parameters where function
can not return output parameters.

Answer / suraj

1)sp are pre comiled so while execution time it save time
2)sp returns many values where as function return only one
value

Answer / saiprasad

u cannot change any datatype in database using udf

u can do everything with a storedprocedure

udf cannot be used in XMl Clause but sp's can be used

Answer / sivacharan svs

Funtion Should Return a value
Procedure may or may not return a value
Function can be used in Your Select Quries
Procedure has to be passed with or with out parameters
Select Getdate() as date
Function returns date time here


The resultant value of the stored procedure can be used in
application where as the resultant value of the stored
procedure is used in a query.

what is the syntax code to oledb to connect oracle

6 Answers   IBM,

If we are not returning any records from the database, which method is to be used?

0 Answers  

Why do we serialize data?

0 Answers  

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

0 Answers  

Which control of the BindingNavigator returns the current position within the data source?

0 Answers  

What is the role of the dataset object in ado.net?

0 Answers  

What is read only and forward only in ado.net?

0 Answers  

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

0 Answers  

How to call the SQL commands asynchronously in ADO.NET version 2.0

4 Answers   DELL,

What is azure ado?

1 Answers  

Can we load multiple tables in a dataset?

0 Answers  

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

0 Answers