咨询SQL类问题要说清楚你是SqlServer?oracle?mysql?还是啥
sql不一样语法还是有区别的
---------
create trigger A表售价UP
on A表
for update
as
if (update(售价) )
begin
set nocount on;
declare
@ID_ NVARCHAR(4000),
@售价 NVARCHAR(4000)
SELECT @ID_=物料ID,@售价=售价 FROM inserted
update b表 SET 售价=''+CONVERT(NVARCHAR(1000),@售价)+'' WHERE 物料ID=''+CONVERT(NVARCHAR(1000),@ID_)+''
end