How to update data in two tables related by foreign key?

Question

SQL Server

There are two tables connected by foreign keys, and you need to change them at the same time. How can I do that?
DB - MS SQL.
Tried wrapping updates in commits - didn't work

Begin Tran
Update...
Update...
Commit Tran

The base structure is something like this

[Работники]
int Id

[Заказы]
int Id

[Услуги]
int id

[Услуги в заказах]
int ЗаказId
int УслугаId

// Работники вынесены в отдельную таблицу потому, что разные работники могут делать разные услуги в одном заказе, а некоторые услуги могут быть без работников вообще
[Работники в услугах в заказах]
int ЗаказId
int УслугаId
int РаботникId

Need to update the last two tables

Answer 1

MS SQL does not support delayed integrity checking. You can temporarily disable checks during a transaction and then enable them again. But it is better to rework the data structure or, alternatively, use a DBMS in which this feature exists.

Answer 2

Delete the old one and add with new values.