CREATE TRIGGER  [dbo].[tigger_update]
   ON  [UFTData231275_000002].[dbo].[SA_SaleDelivery]
   AFTER update
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    declare @saledeliveryorder nvarchar(50)
    select @saledeliveryorder=[SourceVoucherCode] from [UFTData231275_000002].[dbo].[SA_SaleDelivery]
    declare @id int
    select top 1 @id=[id]  FROM [UFTData231275_000002].[dbo].[SA_SaleOrder_b] order by [id] desc
    declare @saleorder nvarchar(50)
     select @saleorder=[code] from [UFTData231275_000002].[dbo].[SA_SaleDelivery] where [ID]= ( select [idSaleOrderDTO]  FROM [UFTData231275_000002].[dbo].[SA_SaleOrder_b] where [id]=@id)
    declare @s nvarchar(50)
    select  @s=[code] from [UFTData231275_000002].[dbo].[SA_SaleDelivery] where [SourceVoucherCode]=@saledeliveryorder
    update [UFTData231275_000002].[dbo].[SA_SaleOrder_b] set [priuserdefnvc1] =@s where [id]=@id
END
GO
创建数据库之后没什么就不能修改数据了