DECLARE @NUM INT SET @NUM=0 update tabGa set aaa=@NUM,@NUM=@nUM+1?
DECLARE @NUM INT SET @NUM=0 update tabGa set aaa=@NUM,@NUM=@nUM+1
这样应该明白了吧-- ============================================= -- Author: T.O.P -- Create date: 20091126 -- Version: SQL SERVER 2000 -- ============================================= declare @tb1 table([A] varchar(2),[B] int) insert @tb1 select 'A1',0 union all select 'A2',0 union all select 'A3',0 union all select 'A4',0DECLARE @A INT SET @A=0UPDATE @TB1 SET B = @A, @A = @A+1SELECT * FROM @TB1 --测试结果: /* A B ---- ----------- A1 1 A2 2 A3 3 A4 4(所影响的行数为 4 行) */
DECLARE @NUM INT
SET @NUM=0
update tabGa set aaa=@NUM,@NUM=@nUM+1?
SET @NUM=0
update tabGa set aaa=@NUM,@NUM=@nUM+1
这样应该明白了吧-- =============================================
-- Author: T.O.P
-- Create date: 20091126
-- Version: SQL SERVER 2000
-- =============================================
declare @tb1 table([A] varchar(2),[B] int)
insert @tb1
select 'A1',0 union all
select 'A2',0 union all
select 'A3',0 union all
select 'A4',0DECLARE @A INT
SET @A=0UPDATE @TB1
SET B = @A, @A = @A+1SELECT * FROM @TB1
--测试结果:
/*
A B
---- -----------
A1 1
A2 2
A3 3
A4 4(所影响的行数为 4 行)
*/