sql server insert触发器进行扩库的操作

USE [当前数据库名]
GO
/****** Object:  Trigger [dbo].[T_SAL_OUTSTOCK_insert]    Script Date: 08/15/2019 15:15:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[表名_insert]
   ON  [dbo].[表名]
   AFTER  INSERT
AS 
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for trigger here

declare    定义字段
    declare @FBILLNO nvarchar(50); --单据编码
    declare @FDATE nvarchar(50); --日期
    declare @FSALEORGID nvarchar(50); --销售组织
    declare @FCUSTOMERID nvarchar(50); --客户
    declare @FMATERIALID nvarchar(50); --物料编码
    select @FBILLNO=FBILLNO, @FDATE=FDATE,@FSALEORGID=FSALEORGID,@FCUSTOMERID=FCUSTOMERID from inserted;     对字段进行赋值
    INSERT INTO [写入的数据库名].dbo.表名(字段) VALUES (对应的额字段值);
END