SQLServer里面写触发器更新不同数据库数据

举例说明：

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[tgr_khdh] on [dbo].[order1] for insert
AS
DECLARE
    @amount INT,
    @Name VARCHAR(100);
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    

    -- Insert statements for trigger here
     select @amount=sum(amount) from order1;
    
    insert into VATTI..StoreSale values(@amount,'衣服','2012-12-10 10:10:20',1);
    update VATTI..Product set storage=storage-@amount where id=1;

END

上面颜色部分一定要注意，是【数据库】..【表名】。中间是两点。