Answer / chandra shaker

Stored Procedure returns morethan one value where as
Function returns only one value.

Answer / ranjanimanuel

1.UDF can't use a nondeterministic functions such as Getdate
(),RAND() where as StoreProcedure cn use such a functions.
2.UDF must return a value or a single resultset . Store
Procedure can return a value or even multiple resultsets,
but doesn't have to
3. UDF can be used in anywhere sql statements like
where/having/Select sections where as store procedure
cannot be.
4.UDFs that return table can be treated as another rowset.
This can be used in JOINS with other table

Answer / gowdhami

In UDF if any error comes it will stop the execution
but in SP it will skip the step move to next line

Answer / sharad kulat

Store Procedure Is first tme complie and make the
Execution plan & next time proc just call plan .so its get
execute fast.In case Function compile every request.

function & Store procedure return not only single but also
number of value .

function return number of value useing return type table.

You Can use Function with select ,case Statement ,same
thing can not do through Store procedure.

Answer / lalit raghuvanshi

20 main differences between Stored procedures and Functions
in Sql Server
http://www.webcodeexpert.com/2013/04/difference-between-stored-procedures.html

Answer / santosh kumar

Sl. No. User Defined function Stored Procedure
1 Function must return a value. Stored procedure may or not return values.
2 Will allow only Select statement, it will not allow us to use DML statements. Can have select statements as well as DML statements such as insert, update, delete
etc
3 It will allow only input parameters, doesn’t support output parameters. It can have both input and output parameters.
4 It will not allow us to use try-catch blocks. For exception handling we can use try catch blocks.
5 Transactions are not allowed within functions. Can use transactions within Stored procefures.
6 We can use only table variables, it will not allow using temporary tables. Can use both table variables aswell as temporary table in it.
7 Stored procedures can’t be called from function. Stored Procedures can call functions.
8 Functions can be called from select statement. Procedures can’t be called from Select/Where/Having etc statements. Execute/Exec
statement can be used to call/execute stored procedure.
9 UDF can be used in join clause as a result set. Procedures can’t be used in Join clause

Answer / asha

no difference

How can we perform transactions in .net?

0 Answers  

What's the difference between Dataset.clone and Dataset.copy?

10 Answers   Ksb,

What is Debug.write does?

1 Answers  

How do you filter the data in datagrid?

2 Answers   Apps Lab, Choice Solutions,

Which method is used to sort the data in ADO.Net?

0 Answers  

Can a DataReader be used as a DataSource for a GridView. If it is so how will you handle paging.

3 Answers   Directi,

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

0 Answers  

What is the difference between the clone() and copy() methods of the dataset class?

0 Answers  

differences between ADO and ADO.NET

0 Answers   Microsoft,

What is an orm, and why would you use one instead of plain old ado.net?

0 Answers  

describe the dataset object in ado.net.

0 Answers  

What is the difference between Optimistic and Pessimistic locking?

0 Answers