[步骤]
(@p1 bigint,@p2 bigint,@p3 nvarchar(19),@p4 nvarchar(19))SELECT top 5000 * FROM RB_FirstOrder_OrderSourceSku WHERE ID>@p1 AND CustomerID=@p2 AND UpdateTime>=@p3 AND UpdateTime<@p4 ORDER BY ID;
[结果]
[期望]
改成读库拉取数据，且补充 nolock重现步骤
[步骤]
(@p1 bigint,@p2 bigint,@p3 nvarchar(19),@p4 nvarchar(19))SELECT top 5000 * FROM RB_FirstOrder_OrderSourceSku WHERE ID>@p1 AND CustomerID=@p2 AND UpdateTime>=@p3 AND UpdateTime<@p4 ORDER BY ID;
[结果]
[期望]
改成读库拉取数据，且补充 nolock