/*創(chuàng)建名為#TableUpdate的測(cè)試表*/
create table #TableUpdate(id int)
/*插入測(cè)試數(shù)據(jù)*/
declare @a int
   select @a=1
while @a<=10
  begin
     insert into #TableUpdate select @a
     select @a=@a+1
  end

--select * from #TableUpdate
/*刪除部分?jǐn)?shù)據(jù)，進(jìn)行測(cè)試*/
delete from #TableUpdate where id in (2,4,6)
/*進(jìn)行重新排序*/
declare @a int
select @a=0
update #TableUpdate set  id=@a,
                         @a=@a+1
/*查詢(xún)結(jié)果，結(jié)果已經(jīng)被更新*/                      
select * from #TableUpdate