Differnce between Stored procedure and user defined functions?

Answers were Sorted based on User's Feedback



Differnce between Stored procedure and user defined functions?..

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.

Is This Answer Correct ?    32 Yes 4 No

Differnce between Stored procedure and user defined functions?..

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.

Is This Answer Correct ?    21 Yes 4 No

Differnce between Stored procedure and user defined functions?..

Answer / ramesh

stored proc is a precompiled one.

Is This Answer Correct ?    18 Yes 1 No

Differnce between Stored procedure and user defined functions?..

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

Is This Answer Correct ?    17 Yes 1 No

Differnce between Stored procedure and user defined functions?..

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

Is This Answer Correct ?    15 Yes 3 No

Differnce between Stored procedure and user defined functions?..

Answer / ramesh

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

Is This Answer Correct ?    14 Yes 5 No

Differnce between Stored procedure and user defined functions?..

Answer / urvish

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

Is This Answer Correct ?    12 Yes 4 No

Differnce between Stored procedure and user defined functions?..

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

Is This Answer Correct ?    10 Yes 2 No

Differnce between Stored procedure and user defined functions?..

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

Is This Answer Correct ?    6 Yes 0 No

Differnce between Stored procedure and user defined functions?..

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.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

Why is it important to close an ado.net application?

0 Answers  


What is the difference between typed and untyped dataset?

0 Answers  


When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency

4 Answers   Digital Group,


What are the classes in System.Data.Common Namespace?

0 Answers  


Which method do you invoke on the DataAdapter control to load your generated dataset with data?

4 Answers  


How to work with disconnected data - the dataset and sqldataadapter?

0 Answers  


What is difference between ado.net and asp net?

0 Answers  


What is connection in ado.net?

0 Answers  


How to connect and retrieve data from database using dataset

0 Answers  


Which ado.net object is very fast in getting data from the database?

0 Answers  


What is bubbled event can you please explain?

0 Answers  


What is difference between entity framework and ado.net?

0 Answers  


Categories