Why i am getting extra (1 row(s) affected)

Question

i am updating sql server table and updating only one record.but i am getting message (1 row(s) affected) so many times why so? My query is as :

UPDATE V2HRMS.dbo.tbl_pm_employee
    SET LeavingDate='06-26-2013'
       ,Status=1 
WHERE EmployeeCode=3407

This is just for my knowledge.

Answer 1

That usually means you have the actual execution plan option turned on. The execution plan is sent as an extra rowset, resulting in an extra (1 row(s) affected) message

To disable actual execution plan press Ctrl+M