首先
select RecId,RegTime into #Tmps from Users where id in(select [user_id] from Manuscript where Projects_id='173676' and Manuscript_state=4)打个比方 我这条语句插入的数据为:
RecId RegTime
1 2010-1-1
2 2010-2-2
3 2010-3-3
4 2010-4-4
接着执行下面语句
declear @count int
declear @i int
set @i=0
select @coutn=count([user_id]) from Manuscript where Projects_id='173676' and Manuscript_state=4
while @i<@count
begin
我想做的事情:按照顺序取出 RegTime ,注意这里的顺序是按照红色SQL语句所查询的顺序 ,请教大家了 谢谢set @i=@i+1
end
select RecId,RegTime into #Tmps from Users where id in(select [user_id] from Manuscript where Projects_id='173676' and Manuscript_state=4)打个比方 我这条语句插入的数据为:
RecId RegTime
1 2010-1-1
2 2010-2-2
3 2010-3-3
4 2010-4-4
接着执行下面语句
declear @count int
declear @i int
set @i=0
select @coutn=count([user_id]) from Manuscript where Projects_id='173676' and Manuscript_state=4
while @i<@count
begin
我想做的事情:按照顺序取出 RegTime ,注意这里的顺序是按照红色SQL语句所查询的顺序 ,请教大家了 谢谢set @i=@i+1
end
解决方案 »
- SQL2005標準版能否支持兩顆四核共八核的CPU
- 可不可以通过 SQLServer服务器名获取 IP 地址?
- 从EXCEL中导入数据库中时.出现日期格式不对如何处理?急.在线等.
- sql循环打印问题! 求解决方法!
- !!请教,关于连接查询
- sql 行转列,高手进
- iis日志海量数据时如何处理的?一天有100多万条
- How to use the new function fn_get_sql()
- 结果怎么是按ID排序的呀?
- 我是新手,请问如何在vb中找到msdn文件?为什么我总装不上去?请各位高手赐教,小女子感激不尽。
- 求教数据库截取字段中的方法
- EXCEL导入sqlserver数据库,为什么出现问号
for select RecId,RegTime
from Users
where id in(select [user_id] from Manuscript where Projects_id='173676' and Manuscript_state=4)open cur fetch next from cur into @id,@time
while @@fetch_status=0
begin
-- 你想做的事
fetch next from cur into @id,@time
end
close cur
deallocate cur
go
游标的基本写法declare @id int,@name varchar(20);
declare cur cursor fast_forward for
select id,name from a;
open cur;
fetch next from cur into @id,@name;
while @@fetch_status=0
begin
--做你要做的事
fetch next from cur into @id,@name;
end
close cur;
deallocate cur;
我想做的事就是在循环里面取 临时表里面的RegTime
第一次
REGID为1 取时间就为2010-1-1
第二次
2 取时间就为2010-2-2
一次类推
相当于.NET的循环
declare cur cursor fast_forward for
select id,name from a;
open cur;
fetch next from cur into @id,@name;
while @@fetch_status=0
begin
--做你要做的事
-- @id 就是 RecId,,@name 就是 RegTime fetch next from cur into @id,@name;
end
close cur;
deallocate cur;