摘要:
15秒跟2秒之间的区别 UPDATE a SET flag = 1 FROM LINK_39.test_01.dbo.NSB_test AS a WHERE bh IN ( SELECT TOP 500 bh FROM LINK_39.test_01.dbo.NSB_test WHERE bh IS NOT NULL ORDER BY bh )DECLARE @bh VARCHAR(MAX)= '' SELECT @bh = @bh + ',' + CAST(CAST(bh AS INT) AS VARCHAR(10)) FROM ( SELECT TOP 50 阅读全文