create trigger update_OrderDetail
on UserOrder
for update
as
update OrderDetail set Status = UserOrder .Status from UserOrder on UserOrder.id = OrderDetail.id
create trigger update_OrderDetail
on UserOrder
for update
as
update OrderDetail set Status = UserOrder .Status from UserOrder on UserOrder.id = OrderDetail.id
