摘要: 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 阅读全文
posted @ 2012-06-28 17:27 qanholas 阅读(1393) 评论(0) 推荐(0) 编辑
点击右上角即可分享
微信分享提示