Differnce between Stored procedure and user defined functions?

Answer Posted / gowdhami

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between Dataview and Datatable?

539


How will you fill the gridview by using datatable object at runtime?

562


What is difference between executequery and executeupdate?

510


What is ado.net components?

515


Why do we need ado.net?

554






Does sqlclient and oledb class share the same functionality?

543


Which property is used to check whether a DataReader is closed or opened?

574


What are the advantages of oledb compared with other classes?

2331


What is aggregate root?

499


Which is faster datareader or dataadapter?

541


What is Dataset Object?

571


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

589


how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....

3727


What is the difference between Optimistic and Pessimistic locking?

555


What are the different ado.net namespaces?

632