重现步骤

[步骤]


declare @p3 dbo.Tb_Ids insert into @p3 values(199330625)insert into @p3 values(199330671)insert into @p3 values(199331052)insert into @p3 values(198811844)insert into @p3 values(199330651)insert into @p3 values(199330709)insert into @p3 values(199331184)insert into @p3 values(199330105)insert into @p3 values(199330702)insert into @p3 values(199330619)insert into @p3 values(199331050)insert into @p3 values(199331032)insert into @p3 values(199331143)insert into @p3 values(199331213)insert into @p3 values(199331036)insert into @p3 values(199331373)insert into @p3 values(199331399)insert into @p3 values(199331185)insert into @p3 values(199268504)insert into @p3 values(199330256)insert into @p3 values(199330267)insert into @p3 values(199330093)insert into @p3 values(199332077)insert into @p3 values(199332090)insert into @p3 values(199330322)insert into @p3 values(199330301)insert into @p3 values(199330437)insert into @p3 values(199330371)insert into @p3 values(199330387)insert into @p3 values(199330500)insert into @p3 values(199330346)insert into @p3 values(199330457)insert into @p3 values(199330430)insert into @p3 values(199330526)insert into @p3 values(199330464)insert into @p3 values(199330377)insert into @p3 values(199331171)insert into @p3 values(199331153)insert into @p3 values(199331107)insert into @p3 values(199330599)insert into @p3 values(199332121)insert into @p3 values(199332131)insert into @p3 values(199331913)insert into @p3 values(199331851)insert into @p3 values(199331725)insert into @p3 values(199332032)insert into @p3 values(199331935)insert into @p3 values(199331811)insert into @p3 values(199331648)insert into @p3 values(199332026)insert into @p3 values(199332161)insert into @p3 values(199331779)insert into @p3 values(199332236)insert into @p3 values(199332233)insert into @p3 values(199331783)insert into @p3 values(199332223)insert into @p3 values(199333586)insert into @p3 values(199333578)insert into @p3 values(199333564)insert into @p3 values(199331229)insert into @p3 values(199331218)insert into @p3 values(199331275)insert into @p3 values(199331368)insert into @p3 values(199331271)insert into @p3 values(199331375)insert into @p3 values(199330367)insert into @p3 values(199330226)insert into @p3 values(199331393)insert into @p3 values(199330375)insert into @p3 values(199329574)insert into @p3 values(199326470)insert into @p3 values(199330532)insert into @p3 values(199330247)insert into @p3 values(199330326)insert into @p3 values(199330378)insert into @p3 values(199330348)insert into @p3 values(199332595)insert into @p3 values(199330332)insert into @p3 values(199331223)insert into @p3 values(199331823)insert into @p3 values(199320762)insert into @p3 values(199332212)insert into @p3 values(199327961)insert into @p3 values(199328902)insert into @p3 values(199331798)insert into @p3 values(199330472)insert into @p3 values(199331742)insert into @p3 values(199329745)insert into @p3 values(199331217)insert into @p3 values(199332600)insert into @p3 values(199331785)insert into @p3 values(199333585)insert into @p3 values(199330360)insert into @p3 values(199330383)insert into @p3 values(199330305)insert into @p3 values(199331872)insert into @p3 values(199330274)insert into @p3 values(199159186)insert into @p3 values(199332074)insert into @p3 values(199330538)insert into @p3 values(199331834)insert into @p3 values(199329916)insert into @p3 values(199331755)insert into @p3 values(199331243)insert into @p3 values(199329732)insert into @p3 values(199331819)insert into @p3 values(199331815)insert into @p3 values(199330407)insert into @p3 values(199329828)insert into @p3 values(199330352)insert into @p3 values(199330388)insert into @p3 values(199328979)insert into @p3 values(199330334)insert into @p3 values(199330278)insert into @p3 values(199332030)insert into @p3 values(199330520)insert into @p3 values(199329313)insert into @p3 values(199329595)insert into @p3 values(199329718)insert into @p3 values(199330372)insert into @p3 values(199330351)insert into @p3 values(199330259)insert into @p3 values(199331885)insert into @p3 values(199332093)insert into @p3 values(199331879)insert into @p3 values(199330551)insert into @p3 values(199330251)insert into @p3 values(199330349)insert into @p3 values(199330525)insert into @p3 values(199330304)insert into @p3 values(199331010)insert into @p3 values(199330230)insert into @p3 values(199329753)insert into @p3 values(199329586)insert into @p3 values(199330271)insert into @p3 values(199329580)insert into @p3 values(199329624)insert into @p3 values(199329005)insert into @p3 values(199332180)insert into @p3 values(199328922)insert into @p3 values(199330990)insert into @p3 values(199330079)insert into @p3 values(199329954)insert into @p3 values(199328421)insert into @p3 values(199331008)insert into @p3 values(199330254)insert into @p3 values(199328826)insert into @p3 values(199272173)insert into @p3 values(199329918)insert into @p3 values(199328390)insert into @p3 values(199303038)insert into @p3 values(199330246)insert into @p3 values(199330542)insert into @p3 values(199330544)insert into @p3 values(199329073)insert into @p3 values(199330380)insert into @p3 values(199329700)insert into @p3 values(199329345)insert into @p3 values(199330373)insert into @p3 values(199328944)insert into @p3 values(199325644)insert into @p3 values(199326720)insert into @p3 values(199330249)insert into @p3 values(199329626)insert into @p3 values(199331876)insert into @p3 values(199330358)insert into @p3 values(199330461)insert into @p3 values(199325547)insert into @p3 values(199331000)insert into @p3 values(199328820)insert into @p3 values(199330492)insert into @p3 values(199325428)insert into @p3 values(199326895)insert into @p3 values(199331268)insert into @p3 values(199325423)insert into @p3 values(199319819)insert into @p3 values(199329826)insert into @p3 values(199328411)insert into @p3 values(199328342)insert into @p3 values(199331250)insert into @p3 values(199331230)insert into @p3 values(199329601)insert into @p3 values(199326728)insert into @p3 values(199326737)insert into @p3 values(199330505)insert into @p3 values(199328186)insert into @p3 values(199330452)insert into @p3 values(199330392)insert into @p3 values(199330257)insert into @p3 values(199330486)insert into @p3 values(199328991)insert into @p3 values(199329351)insert into @p3 values(199330607)insert into @p3 values(199330587)insert into @p3 values(199330487)insert into @p3 values(199332105)insert into @p3 values(199333562)insert into @p3 values(199328348)insert into @p3 values(199330679)insert into @p3 values(199330262)exec sp_executesql N'UPDATE oi SET oi.DispatchUpdatePlatformTime = Getdate()             FROM RB_OrderInfo oi            INNER JOIN @tb_OrderCode tb_OrderCode ON oi.Id=tb_OrderCode.Id ',N'@tb_OrderCode  [Tb_Ids] READONLY',@tb_OrderCode =@p3


语句较长,系统解析运行时间长,特别是资源紧张的时候  2 类型不一致 IDs 定义为 int 类型  @tb_OrderCode  的返回值 为varchar 

[结果]


[期望]

改成表值参数模式 2. 保证完整的类型一致。


历史记录  
  1. 2024-08-22 09:23:20, 由 袁慧斌 创建。
  2. 2024-08-22 09:23:46, 由 李乐同 指派给 程伟。
    修改了 指派给,旧值为 "liletong",新值为 "chengwei"。
  3. 2024-08-22 09:27:33, 由 袁慧斌 编辑。
    修改了 解决时效,旧值为 "0",新值为 "-1"。
    修改了 重现步骤,区别为:
    002-
    002+
    003- declare @p3 dbo.Tb_Ids insert into @p3 values(199330625)insert into @p3 values(199330671)insert into @p3 values(199331052)insert into @p3 values(198811844)insert into @p3 values(199330651)insert into @p3 values(199330709)insert into @p3 values(199331184)insert into @p3 values(199330105)insert into @p3 values(199330702)insert into @p3 values(199330619)insert into @p3 values(199331050)insert into @p3 values(199331032)insert into @p3 values(199331143)insert into @p3 values(199331213)insert into @p3 values(199331036)insert into @p3 values(199331373)insert into @p3 values(199331399)insert into @p3 values(199331185)insert into @p3 values(199268504)insert into @p3 values(199330256)insert into @p3 values(199330267)insert into @p3 values(199330093)insert into @p3 values(199332077)insert into @p3 values(199332090)insert into @p3 values(199330322)insert into @p3 values(199330301)insert into @p3 values(199330437)insert into @p3 values(199330371)insert into @p3 values(199330387)insert into @p3 values(199330500)insert into @p3 values(199330346)insert into @p3 values(199330457)insert into @p3 values(199330430)insert into @p3 values(199330526)insert into @p3 values(199330464)insert into @p3 values(199330377)insert into @p3 values(199331171)insert into @p3 values(199331153)insert into @p3 values(199331107)insert into @p3 values(199330599)insert into @p3 values(199332121)insert into @p3 values(199332131)insert into @p3 values(199331913)insert into @p3 values(199331851)insert into @p3 values(199331725)insert into @p3 values(199332032)insert into @p3 values(199331935)insert into @p3 values(199331811)insert into @p3 values(199331648)insert into @p3 values(199332026)insert into @p3 values(199332161)insert into @p3 values(199331779)insert into @p3 values(199332236)insert into @p3 values(199332233)insert into @p3 values(199331783)insert into @p3 values(199332223)insert into @p3 values(199333586)insert into @p3 values(199333578)insert into @p3 values(199333564)insert into @p3 values(199331229)insert into @p3 values(199331218)insert into @p3 values(199331275)insert into @p3 values(199331368)insert into @p3 values(199331271)insert into @p3 values(199331375)insert into @p3 values(199330367)insert into @p3 values(199330226)insert into @p3 values(199331393)insert into @p3 values(199330375)insert into @p3 values(199329574)insert into @p3 values(199326470)insert into @p3 values(199330532)insert into @p3 values(199330247)insert into @p3 values(199330326)insert into @p3 values(199330378)insert into @p3 values(199330348)insert into @p3 values(199332595)insert into @p3 values(199330332)insert into @p3 values(199331223)insert into @p3 values(199331823)insert into @p3 values(199320762)insert into @p3 values(199332212)insert into @p3 values(199327961)insert into @p3 values(199328902)insert into @p3 values(199331798)insert into @p3 values(199330472)insert into @p3 values(199331742)insert into @p3 values(199329745)insert into @p3 values(199331217)insert into @p3 values(199332600)insert into @p3 values(199331785)insert into @p3 values(199333585)insert into @p3 values(199330360)insert into @p3 values(199330383)insert into @p3 values(199330305)insert into @p3 values(199331872)insert into @p3 values(199330274)insert into @p3 values(199159186)insert into @p3 values(199332074)insert into @p3 values(199330538)insert into @p3 values(199331834)insert into @p3 values(199329916)insert into @p3 values(199331755)insert into @p3 values(199331243)insert into @p3 values(199329732)insert into @p3 values(199331819)insert into @p3 values(199331815)insert into @p3 values(199330407)insert into @p3 values(199329828)insert into @p3 values(199330352)insert into @p3 values(199330388)insert into @p3 values(199328979)insert into @p3 values(199330334)insert into @p3 values(199330278)insert into @p3 values(199332030)insert into @p3 values(199330520)insert into @p3 values(199329313)insert into @p3 values(199329595)insert into @p3 values(199329718)insert into @p3 values(199330372)insert into @p3 values(199330351)insert into @p3 values(199330259)insert into @p3 values(199331885)insert into @p3 values(199332093)insert into @p3 values(199331879)insert into @p3 values(199330551)insert into @p3 values(199330251)insert into @p3 values(199330349)insert into @p3 values(199330525)insert into @p3 values(199330304)insert into @p3 values(199331010)insert into @p3 values(199330230)insert into @p3 values(199329753)insert into @p3 values(199329586)insert into @p3 values(199330271)insert into @p3 values(199329580)insert into @p3 values(199329624)insert into @p3 values(199329005)insert into @p3 values(199332180)insert into @p3 values(199328922)insert into @p3 values(199330990)insert into @p3 values(199330079)insert into @p3 values(199329954)insert into @p3 values(199328421)insert into @p3 values(199331008)insert into @p3 values(199330254)insert into @p3 values(199328826)insert into @p3 values(199272173)insert into @p3 values(199329918)insert into @p3 values(199328390)insert into @p3 values(199303038)insert into @p3 values(199330246)insert into @p3 values(199330542)insert into @p3 values(199330544)insert into @p3 values(199329073)insert into @p3 values(199330380)insert into @p3 values(199329700)insert into @p3 values(199329345)insert into @p3 values(199330373)insert into @p3 values(199328944)insert into @p3 values(199325644)insert into @p3 values(199326720)insert into @p3 values(199330249)insert into @p3 values(199329626)insert into @p3 values(199331876)insert into @p3 values(199330358)insert into @p3 values(199330461)insert into @p3 values(199325547)insert into @p3 values(199331000)insert into @p3 values(199328820)insert into @p3 values(199330492)insert into @p3 values(199325428)insert into @p3 values(199326895)insert into @p3 values(199331268)insert into @p3 values(199325423)insert into @p3 values(199319819)insert into @p3 values(199329826)insert into @p3 values(199328411)insert into @p3 values(199328342)insert into @p3 values(199331250)insert into @p3 values(199331230)insert into @p3 values(199329601)insert into @p3 values(199326728)insert into @p3 values(199326737)insert into @p3 values(199330505)insert into @p3 values(199328186)insert into @p3 values(199330452)insert into @p3 values(199330392)insert into @p3 values(199330257)insert into @p3 values(199330486)insert into @p3 values(199328991)insert into @p3 values(199329351)insert into @p3 values(199330607)insert into @p3 values(199330587)insert into @p3 values(199330487)insert into @p3 values(199332105)insert into @p3 values(199333562)insert into @p3 values(199328348)insert into @p3 values(199330679)insert into @p3 values(199330262)exec sp_executesql N'UPDATE oi SET oi.DispatchUpdatePlatformTime = Getdate() FROM RB_OrderInfo oi INNER JOIN @tb_OrderCode tb_OrderCode ON oi.Id=tb_OrderCode.Id ',N'@tb_OrderCode [Tb_Ids] READONLY',@tb_OrderCode =@p3
    003+
    004-
    004+ declare @p3 dbo.Tb_Ids insert into @p3 values(199330625)insert into @p3 values(199330671)insert into @p3 values(199331052)insert into @p3 values(198811844)insert into @p3 values(199330651)insert into @p3 values(199330709)insert into @p3 values(199331184)insert into @p3 values(199330105)insert into @p3 values(199330702)insert into @p3 values(199330619)insert into @p3 values(199331050)insert into @p3 values(199331032)insert into @p3 values(199331143)insert into @p3 values(199331213)insert into @p3 values(199331036)insert into @p3 values(199331373)insert into @p3 values(199331399)insert into @p3 values(199331185)insert into @p3 values(199268504)insert into @p3 values(199330256)insert into @p3 values(199330267)insert into @p3 values(199330093)insert into @p3 values(199332077)insert into @p3 values(199332090)insert into @p3 values(199330322)insert into @p3 values(199330301)insert into @p3 values(199330437)insert into @p3 values(199330371)insert into @p3 values(199330387)insert into @p3 values(199330500)insert into @p3 values(199330346)insert into @p3 values(199330457)insert into @p3 values(199330430)insert into @p3 values(199330526)insert into @p3 values(199330464)insert into @p3 values(199330377)insert into @p3 values(199331171)insert into @p3 values(199331153)insert into @p3 values(199331107)insert into @p3 values(199330599)insert into @p3 values(199332121)insert into @p3 values(199332131)insert into @p3 values(199331913)insert into @p3 values(199331851)insert into @p3 values(199331725)insert into @p3 values(199332032)insert into @p3 values(199331935)insert into @p3 values(199331811)insert into @p3 values(199331648)insert into @p3 values(199332026)insert into @p3 values(199332161)insert into @p3 values(199331779)insert into @p3 values(199332236)insert into @p3 values(199332233)insert into @p3 values(199331783)insert into @p3 values(199332223)insert into @p3 values(199333586)insert into @p3 values(199333578)insert into @p3 values(199333564)insert into @p3 values(199331229)insert into @p3 values(199331218)insert into @p3 values(199331275)insert into @p3 values(199331368)insert into @p3 values(199331271)insert into @p3 values(199331375)insert into @p3 values(199330367)insert into @p3 values(199330226)insert into @p3 values(199331393)insert into @p3 values(199330375)insert into @p3 values(199329574)insert into @p3 values(199326470)insert into @p3 values(199330532)insert into @p3 values(199330247)insert into @p3 values(199330326)insert into @p3 values(199330378)insert into @p3 values(199330348)insert into @p3 values(199332595)insert into @p3 values(199330332)insert into @p3 values(199331223)insert into @p3 values(199331823)insert into @p3 values(199320762)insert into @p3 values(199332212)insert into @p3 values(199327961)insert into @p3 values(199328902)insert into @p3 values(199331798)insert into @p3 values(199330472)insert into @p3 values(199331742)insert into @p3 values(199329745)insert into @p3 values(199331217)insert into @p3 values(199332600)insert into @p3 values(199331785)insert into @p3 values(199333585)insert into @p3 values(199330360)insert into @p3 values(199330383)insert into @p3 values(199330305)insert into @p3 values(199331872)insert into @p3 values(199330274)insert into @p3 values(199159186)insert into @p3 values(199332074)insert into @p3 values(199330538)insert into @p3 values(199331834)insert into @p3 values(199329916)insert into @p3 values(199331755)insert into @p3 values(199331243)insert into @p3 values(199329732)insert into @p3 values(199331819)insert into @p3 values(199331815)insert into @p3 values(199330407)insert into @p3 values(199329828)insert into @p3 values(199330352)insert into @p3 values(199330388)insert into @p3 values(199328979)insert into @p3 values(199330334)insert into @p3 values(199330278)insert into @p3 values(199332030)insert into @p3 values(199330520)insert into @p3 values(199329313)insert into @p3 values(199329595)insert into @p3 values(199329718)insert into @p3 values(199330372)insert into @p3 values(199330351)insert into @p3 values(199330259)insert into @p3 values(199331885)insert into @p3 values(199332093)insert into @p3 values(199331879)insert into @p3 values(199330551)insert into @p3 values(199330251)insert into @p3 values(199330349)insert into @p3 values(199330525)insert into @p3 values(199330304)insert into @p3 values(199331010)insert into @p3 values(199330230)insert into @p3 values(199329753)insert into @p3 values(199329586)insert into @p3 values(199330271)insert into @p3 values(199329580)insert into @p3 values(199329624)insert into @p3 values(199329005)insert into @p3 values(199332180)insert into @p3 values(199328922)insert into @p3 values(199330990)insert into @p3 values(199330079)insert into @p3 values(199329954)insert into @p3 values(199328421)insert into @p3 values(199331008)insert into @p3 values(199330254)insert into @p3 values(199328826)insert into @p3 values(199272173)insert into @p3 values(199329918)insert into @p3 values(199328390)insert into @p3 values(199303038)insert into @p3 values(199330246)insert into @p3 values(199330542)insert into @p3 values(199330544)insert into @p3 values(199329073)insert into @p3 values(199330380)insert into @p3 values(199329700)insert into @p3 values(199329345)insert into @p3 values(199330373)insert into @p3 values(199328944)insert into @p3 values(199325644)insert into @p3 values(199326720)insert into @p3 values(199330249)insert into @p3 values(199329626)insert into @p3 values(199331876)insert into @p3 values(199330358)insert into @p3 values(199330461)insert into @p3 values(199325547)insert into @p3 values(199331000)insert into @p3 values(199328820)insert into @p3 values(199330492)insert into @p3 values(199325428)insert into @p3 values(199326895)insert into @p3 values(199331268)insert into @p3 values(199325423)insert into @p3 values(199319819)insert into @p3 values(199329826)insert into @p3 values(199328411)insert into @p3 values(199328342)insert into @p3 values(199331250)insert into @p3 values(199331230)insert into @p3 values(199329601)insert into @p3 values(199326728)insert into @p3 values(199326737)insert into @p3 values(199330505)insert into @p3 values(199328186)insert into @p3 values(199330452)insert into @p3 values(199330392)insert into @p3 values(199330257)insert into @p3 values(199330486)insert into @p3 values(199328991)insert into @p3 values(199329351)insert into @p3 values(199330607)insert into @p3 values(199330587)insert into @p3 values(199330487)insert into @p3 values(199332105)insert into @p3 values(199333562)insert into @p3 values(199328348)insert into @p3 values(199330679)insert into @p3 values(199330262)exec sp_executesql N'UPDATE oi SET oi.DispatchUpdatePlatformTime = Getdate() FROM RB_OrderInfo oi INNER JOIN @tb_OrderCode tb_OrderCode ON oi.Id=tb_OrderCode.Id ',N'@tb_OrderCode [Tb_Ids] READONLY',@tb_OrderCode =@p3
    005- 语句较长,系统解析运行时间长,特别是资源紧张的时候 2 类型不一致 IDs 定义为 int 类型 @tb_OrderCode 的返回值 为varchar
    005+
    006- [结果]
    006+ 语句较长,系统解析运行时间长,特别是资源紧张的时候 2 类型不一致 IDs 定义为 int 类型 @tb_OrderCode 的返回值 为varchar
    007- [期望] 改成表值参数模式 2. 保证完整的类型一致。
    007+ [结果]
    008-
    008+ [期望] 改成表值参数模式 2. 保证完整的类型一致。
    009+
    002- <p><br /></p>
    002+ <p><img src="{400001.png}" alt="" /></p>
    003- <p>declare @p3 dbo.Tb_Ids insert into @p3 values(199330625)insert into @p3 values(199330671)insert into @p3 values(199331052)insert into @p3 values(198811844)insert into @p3 values(199330651)insert into @p3 values(199330709)insert into @p3 values(199331184)insert into @p3 values(199330105)insert into @p3 values(199330702)insert into @p3 values(199330619)insert into @p3 values(199331050)insert into @p3 values(199331032)insert into @p3 values(199331143)insert into @p3 values(199331213)insert into @p3 values(199331036)insert into @p3 values(199331373)insert into @p3 values(199331399)insert into @p3 values(199331185)insert into @p3 values(199268504)insert into @p3 values(199330256)insert into @p3 values(199330267)insert into @p3 values(199330093)insert into @p3 values(199332077)insert into @p3 values(199332090)insert into @p3 values(199330322)insert into @p3 values(199330301)insert into @p3 values(199330437)insert into @p3 values(199330371)insert into @p3 values(199330387)insert into @p3 values(199330500)insert into @p3 values(199330346)insert into @p3 values(199330457)insert into @p3 values(199330430)insert into @p3 values(199330526)insert into @p3 values(199330464)insert into @p3 values(199330377)insert into @p3 values(199331171)insert into @p3 values(199331153)insert into @p3 values(199331107)insert into @p3 values(199330599)insert into @p3 values(199332121)insert into @p3 values(199332131)insert into @p3 values(199331913)insert into @p3 values(199331851)insert into @p3 values(199331725)insert into @p3 values(199332032)insert into @p3 values(199331935)insert into @p3 values(199331811)insert into @p3 values(199331648)insert into @p3 values(199332026)insert into @p3 values(199332161)insert into @p3 values(199331779)insert into @p3 values(199332236)insert into @p3 values(199332233)insert into @p3 values(199331783)insert into @p3 values(199332223)insert into @p3 values(199333586)insert into @p3 values(199333578)insert into @p3 values(199333564)insert into @p3 values(199331229)insert into @p3 values(199331218)insert into @p3 values(199331275)insert into @p3 values(199331368)insert into @p3 values(199331271)insert into @p3 values(199331375)insert into @p3 values(199330367)insert into @p3 values(199330226)insert into @p3 values(199331393)insert into @p3 values(199330375)insert into @p3 values(199329574)insert into @p3 values(199326470)insert into @p3 values(199330532)insert into @p3 values(199330247)insert into @p3 values(199330326)insert into @p3 values(199330378)insert into @p3 values(199330348)insert into @p3 values(199332595)insert into @p3 values(199330332)insert into @p3 values(199331223)insert into @p3 values(199331823)insert into @p3 values(199320762)insert into @p3 values(199332212)insert into @p3 values(199327961)insert into @p3 values(199328902)insert into @p3 values(199331798)insert into @p3 values(199330472)insert into @p3 values(199331742)insert into @p3 values(199329745)insert into @p3 values(199331217)insert into @p3 values(199332600)insert into @p3 values(199331785)insert into @p3 values(199333585)insert into @p3 values(199330360)insert into @p3 values(199330383)insert into @p3 values(199330305)insert into @p3 values(199331872)insert into @p3 values(199330274)insert into @p3 values(199159186)insert into @p3 values(199332074)insert into @p3 values(199330538)insert into @p3 values(199331834)insert into @p3 values(199329916)insert into @p3 values(199331755)insert into @p3 values(199331243)insert into @p3 values(199329732)insert into @p3 values(199331819)insert into @p3 values(199331815)insert into @p3 values(199330407)insert into @p3 values(199329828)insert into @p3 values(199330352)insert into @p3 values(199330388)insert into @p3 values(199328979)insert into @p3 values(199330334)insert into @p3 values(199330278)insert into @p3 values(199332030)insert into @p3 values(199330520)insert into @p3 values(199329313)insert into @p3 values(199329595)insert into @p3 values(199329718)insert into @p3 values(199330372)insert into @p3 values(199330351)insert into @p3 values(199330259)insert into @p3 values(199331885)insert into @p3 values(199332093)insert into @p3 values(199331879)insert into @p3 values(199330551)insert into @p3 values(199330251)insert into @p3 values(199330349)insert into @p3 values(199330525)insert into @p3 values(199330304)insert into @p3 values(199331010)insert into @p3 values(199330230)insert into @p3 values(199329753)insert into @p3 values(199329586)insert into @p3 values(199330271)insert into @p3 values(199329580)insert into @p3 values(199329624)insert into @p3 values(199329005)insert into @p3 values(199332180)insert into @p3 values(199328922)insert into @p3 values(199330990)insert into @p3 values(199330079)insert into @p3 values(199329954)insert into @p3 values(199328421)insert into @p3 values(199331008)insert into @p3 values(199330254)insert into @p3 values(199328826)insert into @p3 values(199272173)insert into @p3 values(199329918)insert into @p3 values(199328390)insert into @p3 values(199303038)insert into @p3 values(199330246)insert into @p3 values(199330542)insert into @p3 values(199330544)insert into @p3 values(199329073)insert into @p3 values(199330380)insert into @p3 values(199329700)insert into @p3 values(199329345)insert into @p3 values(199330373)insert into @p3 values(199328944)insert into @p3 values(199325644)insert into @p3 values(199326720)insert into @p3 values(199330249)insert into @p3 values(199329626)insert into @p3 values(199331876)insert into @p3 values(199330358)insert into @p3 values(199330461)insert into @p3 values(199325547)insert into @p3 values(199331000)insert into @p3 values(199328820)insert into @p3 values(199330492)insert into @p3 values(199325428)insert into @p3 values(199326895)insert into @p3 values(199331268)insert into @p3 values(199325423)insert into @p3 values(199319819)insert into @p3 values(199329826)insert into @p3 values(199328411)insert into @p3 values(199328342)insert into @p3 values(199331250)insert into @p3 values(199331230)insert into @p3 values(199329601)insert into @p3 values(199326728)insert into @p3 values(199326737)insert into @p3 values(199330505)insert into @p3 values(199328186)insert into @p3 values(199330452)insert into @p3 values(199330392)insert into @p3 values(199330257)insert into @p3 values(199330486)insert into @p3 values(199328991)insert into @p3 values(199329351)insert into @p3 values(199330607)insert into @p3 values(199330587)insert into @p3 values(199330487)insert into @p3 values(199332105)insert into @p3 values(199333562)insert into @p3 values(199328348)insert into @p3 values(199330679)insert into @p3 values(199330262)exec sp_executesql N'UPDATE oi SET oi.DispatchUpdatePlatformTime = Getdate() FROM RB_OrderInfo oi INNER JOIN @tb_OrderCode tb_OrderCode ON oi.Id=tb_OrderCode.Id ',N'@tb_OrderCode [Tb_Ids] READONLY',@tb_OrderCode =@p3</p>
    003+ <p><br /></p>
    004- <p><br /></p>
    004+ <p>declare @p3 dbo.Tb_Ids insert into @p3 values(199330625)insert into @p3 values(199330671)insert into @p3 values(199331052)insert into @p3 values(198811844)insert into @p3 values(199330651)insert into @p3 values(199330709)insert into @p3 values(199331184)insert into @p3 values(199330105)insert into @p3 values(199330702)insert into @p3 values(199330619)insert into @p3 values(199331050)insert into @p3 values(199331032)insert into @p3 values(199331143)insert into @p3 values(199331213)insert into @p3 values(199331036)insert into @p3 values(199331373)insert into @p3 values(199331399)insert into @p3 values(199331185)insert into @p3 values(199268504)insert into @p3 values(199330256)insert into @p3 values(199330267)insert into @p3 values(199330093)insert into @p3 values(199332077)insert into @p3 values(199332090)insert into @p3 values(199330322)insert into @p3 values(199330301)insert into @p3 values(199330437)insert into @p3 values(199330371)insert into @p3 values(199330387)insert into @p3 values(199330500)insert into @p3 values(199330346)insert into @p3 values(199330457)insert into @p3 values(199330430)insert into @p3 values(199330526)insert into @p3 values(199330464)insert into @p3 values(199330377)insert into @p3 values(199331171)insert into @p3 values(199331153)insert into @p3 values(199331107)insert into @p3 values(199330599)insert into @p3 values(199332121)insert into @p3 values(199332131)insert into @p3 values(199331913)insert into @p3 values(199331851)insert into @p3 values(199331725)insert into @p3 values(199332032)insert into @p3 values(199331935)insert into @p3 values(199331811)insert into @p3 values(199331648)insert into @p3 values(199332026)insert into @p3 values(199332161)insert into @p3 values(199331779)insert into @p3 values(199332236)insert into @p3 values(199332233)insert into @p3 values(199331783)insert into @p3 values(199332223)insert into @p3 values(199333586)insert into @p3 values(199333578)insert into @p3 values(199333564)insert into @p3 values(199331229)insert into @p3 values(199331218)insert into @p3 values(199331275)insert into @p3 values(199331368)insert into @p3 values(199331271)insert into @p3 values(199331375)insert into @p3 values(199330367)insert into @p3 values(199330226)insert into @p3 values(199331393)insert into @p3 values(199330375)insert into @p3 values(199329574)insert into @p3 values(199326470)insert into @p3 values(199330532)insert into @p3 values(199330247)insert into @p3 values(199330326)insert into @p3 values(199330378)insert into @p3 values(199330348)insert into @p3 values(199332595)insert into @p3 values(199330332)insert into @p3 values(199331223)insert into @p3 values(199331823)insert into @p3 values(199320762)insert into @p3 values(199332212)insert into @p3 values(199327961)insert into @p3 values(199328902)insert into @p3 values(199331798)insert into @p3 values(199330472)insert into @p3 values(199331742)insert into @p3 values(199329745)insert into @p3 values(199331217)insert into @p3 values(199332600)insert into @p3 values(199331785)insert into @p3 values(199333585)insert into @p3 values(199330360)insert into @p3 values(199330383)insert into @p3 values(199330305)insert into @p3 values(199331872)insert into @p3 values(199330274)insert into @p3 values(199159186)insert into @p3 values(199332074)insert into @p3 values(199330538)insert into @p3 values(199331834)insert into @p3 values(199329916)insert into @p3 values(199331755)insert into @p3 values(199331243)insert into @p3 values(199329732)insert into @p3 values(199331819)insert into @p3 values(199331815)insert into @p3 values(199330407)insert into @p3 values(199329828)insert into @p3 values(199330352)insert into @p3 values(199330388)insert into @p3 values(199328979)insert into @p3 values(199330334)insert into @p3 values(199330278)insert into @p3 values(199332030)insert into @p3 values(199330520)insert into @p3 values(199329313)insert into @p3 values(199329595)insert into @p3 values(199329718)insert into @p3 values(199330372)insert into @p3 values(199330351)insert into @p3 values(199330259)insert into @p3 values(199331885)insert into @p3 values(199332093)insert into @p3 values(199331879)insert into @p3 values(199330551)insert into @p3 values(199330251)insert into @p3 values(199330349)insert into @p3 values(199330525)insert into @p3 values(199330304)insert into @p3 values(199331010)insert into @p3 values(199330230)insert into @p3 values(199329753)insert into @p3 values(199329586)insert into @p3 values(199330271)insert into @p3 values(199329580)insert into @p3 values(199329624)insert into @p3 values(199329005)insert into @p3 values(199332180)insert into @p3 values(199328922)insert into @p3 values(199330990)insert into @p3 values(199330079)insert into @p3 values(199329954)insert into @p3 values(199328421)insert into @p3 values(199331008)insert into @p3 values(199330254)insert into @p3 values(199328826)insert into @p3 values(199272173)insert into @p3 values(199329918)insert into @p3 values(199328390)insert into @p3 values(199303038)insert into @p3 values(199330246)insert into @p3 values(199330542)insert into @p3 values(199330544)insert into @p3 values(199329073)insert into @p3 values(199330380)insert into @p3 values(199329700)insert into @p3 values(199329345)insert into @p3 values(199330373)insert into @p3 values(199328944)insert into @p3 values(199325644)insert into @p3 values(199326720)insert into @p3 values(199330249)insert into @p3 values(199329626)insert into @p3 values(199331876)insert into @p3 values(199330358)insert into @p3 values(199330461)insert into @p3 values(199325547)insert into @p3 values(199331000)insert into @p3 values(199328820)insert into @p3 values(199330492)insert into @p3 values(199325428)insert into @p3 values(199326895)insert into @p3 values(199331268)insert into @p3 values(199325423)insert into @p3 values(199319819)insert into @p3 values(199329826)insert into @p3 values(199328411)insert into @p3 values(199328342)insert into @p3 values(199331250)insert into @p3 values(199331230)insert into @p3 values(199329601)insert into @p3 values(199326728)insert into @p3 values(199326737)insert into @p3 values(199330505)insert into @p3 values(199328186)insert into @p3 values(199330452)insert into @p3 values(199330392)insert into @p3 values(199330257)insert into @p3 values(199330486)insert into @p3 values(199328991)insert into @p3 values(199329351)insert into @p3 values(199330607)insert into @p3 values(199330587)insert into @p3 values(199330487)insert into @p3 values(199332105)insert into @p3 values(199333562)insert into @p3 values(199328348)insert into @p3 values(199330679)insert into @p3 values(199330262)exec sp_executesql N'UPDATE oi SET oi.DispatchUpdatePlatformTime = Getdate() FROM RB_OrderInfo oi INNER JOIN @tb_OrderCode tb_OrderCode ON oi.Id=tb_OrderCode.Id ',N'@tb_OrderCode [Tb_Ids] READONLY',@tb_OrderCode =@p3</p>
    005- <p>语句较长,系统解析运行时间长,特别是资源紧张的时候 2 类型不一致 IDs 定义为 int 类型 <span>@tb_OrderCode 的返回值 为varchar</span></p>
    005+ <p><br /></p>
    006- <p>[结果]</p>
    006+ <p>语句较长,系统解析运行时间长,特别是资源紧张的时候 2 类型不一致 IDs 定义为 int 类型 <span>@tb_OrderCode 的返回值 为varchar</span></p>
    007- <br /><p>[期望] 改成表值参数模式 2. 保证完整的类型一致。</p>
    007+ <p>[结果]</p>
    008- <br />
    008+ <br /><p>[期望] 改成表值参数模式 2. 保证完整的类型一致。</p>
    009+ <br />
  4. 2024-08-22 10:19:00, 由 程伟 指派给 程伟。

    1. tb_OrderCode 已经是int类型,而且where条件是主键I

    2. 程序已经控制了,一次只会更新200条数据

    3. 我看了上面的慢sql日志截图,这个SQL慢日志很少,而且执行时间没有其他SQL的时间长,是不是其他SQL影响到的

     


    刚刚用SQL重新执行的时候,是秒执行成功的

  5. 2024-08-22 10:48:24, 由 袁慧斌 编辑。
    修改了 解决时效,旧值为 "0",新值为 "1.29"。
    修改了 上线时效,旧值为 "-1",新值为 "17748417.39"。

    exec sp_executesql N'DELETE FROM RB_OrderInfo_Log WHERE ID<@p1 AND CustomerID=@p2 AND AddTime<@p3;',N'@p1 bigint,@p2 bigint,@p3 nvarchar(19)',@p1=1881068089,@p2=1,@p3=N'2024-08-21 00:45:15'  

    直接影响的者  zhcxkj-es-goapi-mssql2es-6574ccb65c-



  6. 2024-08-22 11:04:20, 由 程伟 指派给 黄金龙。
    修改了 指派给,旧值为 "chengwei",新值为 "huangjinlong"。
    订单日志迁移至ES的服务
  7. 2024-08-22 17:32:05, 由 黄金龙 解决,方案为 性能问题 。
    修改了 解决方案,旧值为 "",新值为 "performance"。
    修改了 解决日期,旧值为 "",新值为 "2024-08-22 17:31:04"。
    修改了 指派给 ,旧值为 "huangjinlong",新值为 "yuanhuibin"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "huangjinlong"。
    日志同步到ES后,对删除日志已整改,多次小批量删除,减少死锁。已上线,明天看结果。
  8. 2024-08-23 11:17:32, 由 袁慧斌 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "yuanhuibin",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "yuanhuibin"。
    修改了 关闭日期,旧值为 "",新值为 "2024-08-23 11:17:32"。
所属项目 技术中心-需求池
所属模块 供应链   仓储物流   备库订单
所属计划
所属迭代
Bug类型
严重程度 严重
优先级 P0
Bug状态 已关闭
业务部门
影响功能
开发责任人 黄金龙
测试责任人
解决时效 1.29
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2024-08-23 11:17:32
截止日期 0000-00-00
上线时间 0000-00-00 00:00:00
上线时效 17748400
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2024-08-22 09:23:19
影响环境 577
由谁解决 黄金龙 于 2024-08-22 17:31:04
解决版本
解决方案 性能问题
由谁关闭 袁慧斌 于 2024-08-23 11:17:32
最后修改 袁慧斌 于 2024-08-23 11:17:32
相关Bug