Differnce between Stored procedure and user defined functions?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why edit is not possible in repeater?

522


What are the ado.net components?

527


What is fill method in ado.net?

543


What is difference between Dataview and Datatable?

528


Explain the namespaces in which .net has the data functionality class.

533






How to enable and disable connection pooling?

509


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

580


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

633


What is a serialized object?

538


describe the dataset object in ado.net.

522


What are the rules to implement connection pooling?

508


Explain which name space is used to get assembly details?

530


What are the different ado.net namespaces?

622


What is data relation?

500


How would you connect to database using .NET?

574