'Updating SQL column value results in data loss in another table

I have a table in which I want to update a specifc column value:

UPDATE [db].[table1]
SET Name = 'coder'
WHERE Nr = 14

When I perform this update, I get data loss in another column of another table in the same database (in which the value is updated as well).

Does anybody know if there is a common way to prevent such data loss?

sql sql-update data-loss

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source