数据库触发器求助

  • y
    yancya
    不是开发
    自己摸索着写了一个触发器
    帮忙看下这样使用会有问题么
    1. ALTER trigger [dbo].[test5] on [dbo].[ICStockBill]
    2. FOR insert
    3. as
    4. DECLARE @A INT
    5. select @A = FInterID FROM inserted where ftrantype = 1
    6. SET NOCOUNT ON
    7. begin
    8. IF EXISTS (SELECT 1 FROM inserted WHERE FHeadSelfA0148 = '990348' or FHeadSelfA0148= '990346')
    9. update ICStockBill
    10. set
    11. FHeadSelfA0149 = '0'
    12. where FInterID = @A

    14. ELSE IF EXISTS (SELECT 1 FROM inserted WHERE FHeadSelfA0148 = '990347' )
    15. update ICStockBill
    16. set
    17. FHeadSelfA0149 = '13'
    18. where FInterID = @A
    19. END

    21. begin update
    22. t2 set t2.FEntrySelfA0173 = t1.FHeadSelfA0149 from
    23. icstockbill t1 join icstockbillentry t2 on t1.finterid=t2.finterid
    24. and t1.ftrantype = 1 where t2.FInterID = @A
    25. end

    27. begin update ICStockBillEntry
    28. set
    29. FAuxPrice=FPurchaseAmount/(FQty*(FEntrySelfA0173/100+1)),
    30. FAmount=FPurchaseAmount/(FQty*(FEntrySelfA0173/100+1))*FQty,
    31. FEntrySelfA0170=(FPurchaseAmount/(1+FEntrySelfA0173/100))*FEntrySelfA0173
    32. from ICStockBillEntry
    33. where FInterID = @A
    34. end
    复制代码
  • R
    Romney
    2021年了还有人用数据库触发器？
  • y
    yancya
    没钱找开发 我自己对付着弄一下能用就行
  • y
    yancya
    顶一下。 iOS fly ~
  • m
    manhere
    严禁使用数据库高级特性
  • y
    yancya
    额 不明白。。。我以前用游标 我试了下不用游标一样效果