CODE:N08583341
Error:16_8003_1_-2146232060
SQL: UPDATE [RB_Amazon_ListFinancialEventGroups]
                                    SET DifferTotalAmount = @DifferTotalAmount_1,
                                    UpdateTime=@UpdateTime_1
                                    WHERE
                                      ID=@ID_1 ; UPDATE [RB_Amazon_ListFinancialEventGroups]
                                    SET DifferTotalAmount = @DifferTotalAmount_2,
                                    UpdateTime=@UpdateTime_2
                                    WHERE
                                      ID=@ID_2 ; UPDATE [RB_Amazon_ListFinancialEventGroups]
                                    SET DifferTotalAmount = @DifferTotalAmount_3,
                                    UpdateTime=@UpdateTime_3
                                    WHERE
                                      ID=@ID_3 ; UPDATE [RB_Amazon_ListFinancialEventGroups]
                                    SET DifferTotalAmount = @DifferTotalAmount_4,
                                    UpdateTime=@UpdateTime_4
                                    WHERE
                                      ID=@ID_4 ; UPDATE [RB_Amazon_ListFinancialEventGroups]
                                    SET DifferTotalAmount = @DifferTotalAmount_5,
                                    UpdateTime=@UpdateTime_5
                                    WHERE
                                      ID=@ID_5 ; UPDATE [RB_Amazon_ListFinancialEventGroups]
                                    SET DifferTotalAmount = @DifferTotalAmount_6,

                                    UpdateTime=@UpdateTime_6

MESSAGE:The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.

 在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms)
   在 RB.DALExtendV2.Generate.Finance.RB_Amazon_ListFinancialEventGroupsExtendV2.BatchUpdateGroupsDifferAmount(List`1 updateList)
   在 Biz.Finance.AmazonGroupsIntegrityService.FinancEventGroupIntegrityExecute(Int32 customerId)
   在 PandaBuy.ERP.Web.test3.Button167_Click(Object sender, EventArgs e)
   在 System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   在 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest()
   在 System.Web.UI.Page.ProcessRequest(HttpContext context)
   在 ASP.test3_aspx.ProcessRequest(HttpContext context)

优化建议：

先把所有值装到一个临时表中，一条update

UPDATE p
SET p.DifferTotalAmount = t.DifferTotalAmount_1,
p.UpdateTime=t.@UpdateTime_1
from [RB_Amazon_ListFinancialEventGroups] p inner #tab t on p.id=t.id;