菜鸟学Sql语句

[ezones]

表xxx(aa,bb,cc)
字段aa为int型,bb varchar(50),cc varchar(50)
字段bb和cc都有值字段aa为空,我想在aa上插入编号:1..8,1..8,...

[hisi]

declare @i int
set @i = 0

update 表 set @i = case @i when 8 then 1 else @i + 1 end, aa = @i

[haoK]

DECLARE @intNO INT
SET @intNO = 0

UPDATE A
SET aa = @intNO + 1,
@intNO = (@intNO + 1) % 8
FROM xxx A

[dotbyte]

没明白

[sun20031223]

不太清楚你的要求......

[pbsql]

alter table xxx add id int identity(0,1)
update xxx set aa=(id%8)+1
alter table t drop column id

或者

declare @i int
set @i = 0
update xxx set aa=(@i%8)+1,@i=@i+1