I guess the problem is there is no rows in that select statement, if records found for to the above statement then it will definitely update the columns and return the effected rows count.--------------------------------------------------------------------------------Give respect to your work, Instead of trying to impress your boss.

the return message itself very descriptive, if your message says '0 row affected' it does means, you have no rows that fitted in WHERE conditionin short according to your query, check if column 'UserRegId' is having value '10'Hope it helpsThanksKoolprasd2003Editor, DotNetSpider MVMMicrosoft MVP 2014 [ASP.NET/IIS]

Hi, Lot of Possibilities are there for showing this Error Messages. 1. There is no records in the table based on UserRegid is 102. May be there is no records in the table too.3. Otherwise, That column could not based on Varchar.

So, Share your table structure. Or . Kindly check with the following query before executing the Update Query.