触发器实现sql语句:当修改一条数据的某个字段时,其他数据的这个字段的值也改变
答案:1 悬赏:0 手机版
解决时间 2021-11-26 08:40
- 提问者网友:自食苦果
- 2021-11-25 14:20
触发器实现sql语句:当修改一条数据的某个字段时,其他数据的这个字段的值也改变
最佳答案
- 五星知识达人网友:英雄的欲望
- 2021-11-25 15:26
create trigger trigger_logistics_scheduling_cartype_update
on logistics_scheduling
after update
as
if update(car_type)
declare @updated_carID int
declare @updated_carType varchar(50)
begin
set @updated_carID = (select d.car_id from deleted d,inserted i where d.car_id = i.car_id)
set @updated_carType = (select d.car_type from deleted d,inserted i where d.car_id = i.car_id)
update logistics_scheduling
set car_type = @updated_carType
where car_id = @updated_carID
end
on logistics_scheduling
after update
as
if update(car_type)
declare @updated_carID int
declare @updated_carType varchar(50)
begin
set @updated_carID = (select d.car_id from deleted d,inserted i where d.car_id = i.car_id)
set @updated_carType = (select d.car_type from deleted d,inserted i where d.car_id = i.car_id)
update logistics_scheduling
set car_type = @updated_carType
where car_id = @updated_carID
end
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯