https://alidocs.dingtalk.com/i/nodes/ZX6GRezwJl7BvlK5hrNBlmQMVdqbropQ?utm_scene=team_space
[步骤]
(@p1 decimal(8,7),@p2 bit,@p3 decimal(6,4),@p4 decimal(6,4),@p5 nvarchar(2),@p6 nvarchar(32),@p7 nvarchar(32),@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 datetime,@p13 datetime,@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(31),@p19 nvarchar(223),@p20 nvarchar(4000),@p21 int,
@p22 nvarchar(21)) UPDATE [RB_OrderInfo] SET [ExchangeRMB] = @p1, [IsPay] = @p2, [TotalPrice] = @p3, [ProductTotalPrice] = @p4, [Province] = @p5, [City] = @p6, [PostCode] = @p7, [ShipTime] = @p8, [UpdatePlatformTime] = @p9, [DownLoadUpdateTime] = @p10, [UpdateTime] = @p11, [DispatchUpdatePlatformTime] = @p12, [LastCDKTime] = @p13, [FBA_CarrierName] = @p14, [IsHadEmail] = @p15, [IsASingleInTheEnd] = @p16, [FBA_TransportName] = @p17, [PromotionType] = @p18, [AddressHash] = @p19, [IsHadBlueTag] = @p20 WHERE (([CustomerID] = @p21) AND ([OrderCode] = @p22))
(@p1 decimal(8,7),@p2 bit,@p3 nvarchar(7),@p4 nvarchar(32),@p5 nvarchar(32),@p6 datetime,@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 nvarchar(4000),@p13 nvarchar(4000),@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar
第二条
(234),@p17 nvarchar(4000),@p18 int,@p19 nvarchar(21))UPDATE [RB_OrderInfo] SET [ExchangeRMB] = @p1, [IsPay] = @p2, [Province] = @p3, [City] = @p4, [PostCode] = @p5, [ShipTime] = @p6, [UpdatePlatformTime] = @p7, [DownLoadUpdateTime] = @p8, [UpdateTime] = @p9, [DispatchUpdatePlatformTime] = @p10, [LastCDKTime] = @p11, [FBA_CarrierName] = @p12, [IsHadEmail] = @p13, [IsASingleInTheEnd] = @p14, [FBA_TransportName] = @p15, [AddressHash] = @p16, [IsHadBlueTag] = @p17 WHERE (([CustomerID] = @p18) AND ([OrderCode] = @p19))
第三条
(@p1 bit,@p2 decimal(6,4),@p3 decimal(6,4),@p4 nvarchar(2),@p5 nvarchar(32),@p6 nvarchar(32),@p7 datetime,@p8 datetime,@p9 datetime,@p10 datetime,@p11 datetime,@p12 datetime,@p13 decimal(6,4),@p14 nvarchar(4000),@p15 datetime,@p16 nvarchar(4000),@p17 nvarchar(4000),@p18 nvarchar(4000),@p19 nvarchar(31),@p20 nvarchar(232),@p21 nvarchar(4000),@p22 int,@p23 nvarchar(21))
UPDATE [RB_OrderInfo] SET [IsPay] = @p1, [TotalPrice] = @p2, [ProductTotalPrice] = @p3, [Province] = @p4, [City] = @p5, [PostCode] = @p6, [ShipTime] = @p7, [UpdatePlatformTime] = @p8, [DownLoadUpdateTime] = @p9, [UpdateTime] = @p10, [DispatchUpdatePlatformTime] = @p11, [LastCDKTime] = @p12, [PromotionDiscountAmount] = @p13, [FBA_CarrierName] = @p14, [LatestShipDate] = @p15, [IsHadEmail] = @p16, [IsASingleInTheEnd] = @p17, [FBA_TransportName] = @p18, [PromotionType] = @p19, [AddressHash] = @p20, [IsHadBlueTag] = @p21 WHERE (([CustomerID] = @p22) AND ([OrderCode] = @p23))
第四条
(@p1 nvarchar(14),@p2 decimal(8,7),@p3 decimal(21,20),@p4 bit,@p5 decimal(6,4),@p6 decimal(6,4),@p7 nvarchar(96),@p8 nvarchar(32),@p9 nvarchar(6),@p10 nvarchar(32),@p11 nvarchar(96),@p12 nvarchar(32),@p13 datetime,@p14 datetime,@p15 datetime,@p16 datetime,@p17 datetime,@p18 datetime,@p19 nvarchar(96),@p20 nvarchar(4000),@p21 nvarchar(4000),@p22 nvarchar(4000),@p23 nvarchar(4000),@p24 nvarchar(234),@p25 nvarchar(4000),@p26 int,@p27 nvarchar(21))UPDATE [RB_OrderInfo] SET [PayerId] = @p1, [ExchangeRMB] = @p2, [ExchangeUSD] = @p3, [IsPay] = @p4, [TotalPrice] = @p5, [ProductTotalPrice] = @p6, [FirstName] = @p7, [LastName] = @p8, [Province] = @p9, [City] = @p10, [Address] = @p11, [PostCode] = @p12, [ShipTime] = @p13, [UpdatePlatformTime] = @p14, [DownLoadUpdateTime] = @p15, [UpdateTime] = @p16, [DispatchUpdatePlatformTime] = @p17, [LastCDKTime] = @p18, [Address1] = @p19, [FBA_CarrierName] = @p20, [IsHadEmail] = @p21, [IsASingleInTheEnd] = @p22, [FBA_TransportName] = @p23, [AddressHash] = @p24, [IsHadBlueTag] = @p25 WHERE (([CustomerID] = @p26) AND ([OrderCode] = @p27))
[结果]
[期望]
请 通盘 检查 保证 数据类型 和数据库一致，否则容易出现 参数嗅探 导致 独占锁 系统阻塞