Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)归海一刀published in(发表于) 2014/2/3 6:45:21 按指定排列顺序获取数据的sql语句_[SQL Server教程]
declare @id int --定义游标declare c_test cursor forselect id from t1 select * into #tmp from table1 where 1=2 --构造临时表的结构
OPEN c_test
FETCH NEXT FROM c_test INTO @idWHILE @@FETCH_STATUS = 0BEGIN--按t1中的id顺序插数据到临时表insert into #tmp select id,name from table1 where id=@id FETCH NEXT FROM c_test INTO @idEndClose c_test deallocate c_test*该方法适合需要按照辅助表的顺序重排table的顺序时使用(即辅助表已经存在的情况)
赞 If you have any requirements, please contact webmaster。(如果有什么要求,请联系站长) QQ:154298438 QQ:417480759
赞