逐行处理数据时避免死循环Alexander Kuznetsovhttp://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/04/23/when-you-process-your-rows-one-by-one-avoid......
请读者自行分析,下面的例子就证明了这两种情况:
DECLARE @i1 INT, @i2 INT, @i3 INT;
SELECT @i1=-1, @i2=-1, @i3=-1;
PRINT 'the following SELECT will not change the value of @i1'
PRINT
3/39 首页 上一页 1 2 3 4 5 6 下一页 尾页 |