如何使用条件语句插入多行 [英] how to insert multiple row with conditional Statement

问题描述

insert into AccountTran(YearId, CompanyId, TrType, TranId, DrAccountId, CrAccountId, DebitAmount, CreditAmount, Narration)
values
(@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @BookId, @PartyId, @NetAmount, 0.00,@Remarks),
(@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @PartyId, @BookId, 0.00, @NetAmount, @Remarks),

If @DiscountMainAmt <> 0 
     (@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @BookId, @Discount1AC,        
     @DiscountMainAmt, 0.00,	@Remarks),
    (@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @Discount1AC, @BookId, 0.00, 
     @DiscountMainAmt, @Remarks),

If @DiscountsubAmt <> 0
     (@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @BookId, 
     @Discount1AC,@DiscountMainAmt, 0.00,    @Remarks),
    (@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @Discount1AC, @BookId, 
    0.00,@DiscountMainAmt, @Remarks)

在Sql中是可能的...... ................................................


请帮助我.....

it is Possible in Sql...................................................

please Help me.....

推荐答案

您需要3个单独的插入语句，例如

You need 3 separate insert statements e.g.

insert into AccountTran(YearId, CompanyId, TrType, TranId, DrAccountId, CrAccountId, DebitAmount, CreditAmount, Narration)
values
(@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @BookId, @PartyId, @NetAmount, 0.00,@Remarks),
(@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @PartyId, @BookId, 0.00, @NetAmount, @Remarks)

If @DiscountMainAmt <> 0
insert into AccountTran(YearId, CompanyId, TrType, TranId, DrAccountId, CrAccountId, DebitAmount, CreditAmount, Narration)
values
     (@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @BookId, @Discount1AC,
     @DiscountMainAmt, 0.00,    @Remarks),
    (@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @Discount1AC, @BookId, 0.00,
     @DiscountMainAmt, @Remarks)

If @DiscountsubAmt <> 0
insert into AccountTran(YearId, CompanyId, TrType, TranId, DrAccountId, CrAccountId, DebitAmount, CreditAmount, Narration)
values
     (@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @BookId,
     @Discount1AC,@DiscountMainAmt, 0.00,    @Remarks),
    (@YearId, @CompanyId, 'PurchaseEntry', @PurchaseId, @Discount1AC, @BookId,
    0.00,@DiscountMainAmt, @Remarks)

请注意，我已从前两个语句中删除了最后一个逗号并包含插入... 第二个2语句的行。

另请注意，您没有使用 @DiscountsubAmt 在最后的插入语句中 - 可能只是输入错误。

Note that I've removed the final comma from the first 2 statements and included the insert into ... line for the second 2 statements.
Note also that you are not using @DiscountsubAmt in that final insert statement - probably just a typing error.

这篇关于如何使用条件语句插入多行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！