Differnce between Stored procedure and user defined functions?
Answer Posted / 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.
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Explain which name space is used to get assembly details?
How do you connect to sql server database without using sqlclient?
Describe the command object and its method.
List all the steps in order, to access a database through ado.net?
What is DataRowCollection?
Explain the different row versions available in table?
Define different execute methods of ADO.NET command object ?
What is ole db query?
What is variable view?
Define isolation?
How can we add/remove row's in "datatable" object of "dataset"?
What is the executescalar method?
Can we load multiple tables in a dataset?
What do you mean by performing asynchronous operation using command object?
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....