用游标循环,示例 --游标 if object_id('tb') is not null drop table tb go create table tb(name varchar(10),con int) insert into tb select 'a',1 insert into tb select 'b',2 insert into tb select 'c',3declare cursor_tb cursor for select name ,con FROM tb declare @name varchar(10),@con int open cursor_tb fetch next from cursor_tb into @name, @con while @@FETCH_STATUS = 0 begin select @name,@con--这里操作 fetch next from cursor_tb into @name, @con end close cursor_tb deallocate cursor_tb
set @dt=GetDate()--哪天
select sum(bytecount) from t_DayRecord
where datediff(dd,[time],@dt)=0
--游标
if object_id('tb') is not null
drop table tb
go
create table tb(name varchar(10),con int)
insert into tb select 'a',1
insert into tb select 'b',2
insert into tb select 'c',3declare cursor_tb cursor for
select name ,con FROM tb
declare @name varchar(10),@con int
open cursor_tb
fetch next from cursor_tb
into @name, @con
while @@FETCH_STATUS = 0
begin
select @name,@con--这里操作
fetch next from cursor_tb
into @name, @con
end
close cursor_tb
deallocate cursor_tb