Differnce between Stored procedure and user defined functions?
Answer Posted / urvish
store procedure can return Output Parameters where function
can not return output parameters.
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
What is aggregating data ?
What is the difference between OLEDB Provider and SqlClient?
Define different execute methods of ADO.NET command object ?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
Define ado.net?
What is ole in vb?
What is ado connection?
What does datareader object do?
Give few examples of datareader that is used in different dataproviders.
What is the difference in an abstract class and an interface?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
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?)
What is difference between sqldatareader and sqldataadapter?
What is the advantage of ado.net?
What is commandbuilder in ado.net?