what is execute scalar?

Answer Posted / prabhat saxena

execute scalar return a object type value, by defalut it
will return first row of fst column value, mostly we used
it with aggregate function like sum(),max(),min(),avg()....

Is This Answer Correct ?    13 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List the 4 common ado.net namespaces?

699


What do you know about ADO.NET's objects and methods?

522


How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

527


What are datareaders?

536


How we can provide data to ado.net?

551






Which keyword is used to accept variable number of parameters?

690


What are the 3 major types of connection objects in ado.net?

545


How to aggregating data across related tables?

556


What is the functionality of data provider in ado.net?

491


What is typed dataset ?

682


What are all the different methods under sqlcommand?

524


Define Execute Reader?

596


Which name space is used to get assembly details?

527


What is different between sqlcommand object and command behavior object?

546


Can datareader hold data from multiple tables?

679