Execute nonquery returns no. of afected rows.So if my stored
procedure hav lot of select stmnt, delete stmnt, insert
stmnt..then what does execute nonquery returns in this case?

Answer Posted / suraj

I don'nt have the right ans but i think the question was if
i have lot of delete stmnt, insert stmnt and update
statement...then what does execute nonquery returns in this
case? as for select we use execute reader...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

613


What is variable view?

497


Which is faster sqldataadapter and sqldatareader?

500


How to identify the updated rows in a dataset?

519


What is the role of clr?

531






What is the difference between an ADO.NET Dataset and an ADO Recordset?

550


Which namespaces are used for data access?

623


What are all components of ADO.Net data provider?

609


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

559


What are all the different authentication techniques used to connect to MS SQL Server?

546


What is the meaning of executenonquery?

540


What are the major difference between classic ADO and ADO.NET?

520


What is ado.net architecture?

494


What is ado.net in vb net?

506


What is the DataTableCollection?

575