深圳智汇创想科技有限公司

修改了 指派给，旧值为 "liletong"，新值为 "chengwei"。

修改了 解决时效，旧值为 "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 />

修改了 解决时效，旧值为 "0"，新值为 "1.29"。
修改了 上线时效，旧值为 "-1"，新值为 "17748417.39"。

修改了 指派给，旧值为 "chengwei"，新值为 "huangjinlong"。

修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决日期，旧值为 ""，新值为 "2024-08-22 17:31:04"。
修改了 指派给 ，旧值为 "huangjinlong"，新值为 "yuanhuibin"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "huangjinlong"。

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "yuanhuibin"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "yuanhuibin"。
修改了 关闭日期，旧值为 ""，新值为 "2024-08-23 11:17:32"。