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;