How to update same columns on different tables at the same time?

I have Table-A with a column called serial_number, and Table-B has the same column.

Update a single table is not possible to their linkage, upon attempt though, this is the error:

The UPDATE statement conflicted with the FOREIGN KEY constraint "L_231". The conflict occurred in database "Main", table "dbo.Products". The statement has been terminated.

I know how I can delete the field in both in case I n开发者_JS百科eed to, I just don't know how to update it simultaneously.

Thanks.

---

this is a BAD design. if this isn't a "one time thing" to fix an issue, but part of your applicaion, you need a redesign.

You shouldn't update keys, use a surrogate key (like an identity) instead and then store the serial_number as a plain data column (which can be easily changed).

---

You should be able to set the constraint as ON UPDATE CASCADE.

---

Hello

Good question but ????

one Method is Update trigger

you update in same time on different table