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 the advantage of ado.net?

549


What is ado object model?

519


What is the purpose of using adodb?

511


What are the objects of ado.net?

539


What are the important features of ado.net 2.0?

594






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

572


What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

563


What is serialization and de-serialization in .net?

500


Is bulk insert faster than insert?

499


How to pass multiple tables in datasets simultaneously?

572


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

562


What is connected architecture in ado.net?

526


What are the different row versions available in table?

531


What is the difference between Data adaptor and Data set?

515


oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

1932