What happens if we use Execute NonQuery with select Query?

Aug 28 2012 7:48 AM
I have read many blogs and articles related to this but i didnt got the answer...
Definition says that, Execute Non Query returns only no. of rows affected and does not return colums or rows of table.. 

Interviewer always confuse us with this question..
Kindly give proper ans to it!!

Thanks in advance...

Answers (5)