create trigger tr_dbo.Custo_Info on dbo.Custo_Info
for update
as
begin
update u
set u.[Source]=i.[source],
u.[Customer_pho]=i.[phone]
from Inserted i inner join dbo.Order_Info u on u.[Customer_name]=i.[customer_name]
end
按“执行”显示如下:
消息 2103,级别 15,状态 1,过程 Custo_Info,第 5 行
因为触发器 'tr_dbo.Custo_Info' 的架构不同于目标表或视图的架构,所以无法 创建 该触发器