Values not updating but showing rows affected

Question

THERE IS NO TRIGGER ON THIS TABLE.

I'm facing strange behaviour of sql server. One of the table column value not updating.

Here is the query and output:

Now if I execute the update statement, it executes successfully:

As per update statement all the clientId values should be 10, but it still remains 2. Here the select query result after executing update statement:

I really don't find any possible issue of this behaviour. Please help to solve this puzzle.

This might helpfully to help me:

1. SQL Server 2012 Express
2. Table:

2. Schema: Table schema

3. If I rename the column name clientId to clientId2 or anything then update works. But if I rename the changed column name to clientId with udpated value then the updated values become 2 again.

4. If I keep the columne name same but table name change to Company2 or anything then then clientId values update fine.

5. https://raw.githubusercontent.com/codenamejakir/Demo-Video/master/sqldemo.swf

6. With transaction: https://raw.githubusercontent.com/codenamejakir/Demo-Video/master/SqlLive.swf

Overall I have noticed that if the table name "Company" and column name "ClientId" then column value not updating.

Thanks.