declare @id int
declare @max int
declare @name char(10)
select @max = max(id) from tablename
set @id = @max
select @name = name from tablen where id = @id
while @id > 1 then
begin
update tablename set A.name = B.name from tablename as A , tablename as B where A.id = @id and B.id = @id -1
set @id = @id - 1
end
update tablename set name = @name where id = 1
declare @name1 varchar(20)
declare @name2 varchar(20)
declare @mid int
select identity(int, 2, 1) as aaid,* into @Tmp from table
select @mid = (select max(id) from #Tmp)
select @name1 = (select name from #Tmp where aaid = 1)
select @name2 = (select name from #Tmp where aaid = @mid)
update table set name = @name2 where id = 1
update table set name = @name1 where id = @mid
declare @name varchar(20)
select @name=top 1 name from table order by id desc
update table set name=a.name from table a where id=a.id+1
update table set name=@name where id=1