declare @id int                              --定義游標
declare c_test cursor for
select id from t1                       

select * into #tmp from table1 where 1=2     --構造臨時表的結構

OPEN c_test

FETCH NEXT FROM c_test
INTO @id
WHILE @@FETCH_STATUS = 0
BEGIN
--按t1中的id順序插數據到臨時表
insert into #tmp select id,name from table1 where id=@id  
FETCH NEXT FROM c_test  INTO @id
End
Close c_test                  
deallocate c_test

*該方法適合需要按照輔助表的順序重排table的順序時使用
(即輔助表已經存在的情況)