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

Which is faster sqldataadapter and sqldatareader?

0 Answers  

What is the default view of Data Grid?

5 Answers   TCS,

What providers do you use to connect to oracle database ?

4 Answers   Digital GlobalSoft,

Can you edit data in the Repeater control?

9 Answers  

What is dataadapter in ado.net?

0 Answers  

feature of ADO.Net

11 Answers   Wipro,

What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?

5 Answers  

how can implement dropdownlist in particular of dataset when try to update?

0 Answers   TCS,

Features and disadvantages of dataset?

2 Answers   CarrizalSoft Technologies, Infosys, Microsoft, Sampath Software,

Compare Data Reader & Dataset in ado.net?

0 Answers   MaxSolPro,

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

0 Answers  

what is clustered index?why is it created?

4 Answers   Microsoft, Wipro,