declare @count int declare @Superior varchar(20) declare @countNum int declare CustCursor Cursor for select superior,count(superior) as RecordeCount from [stuff] group by Superior for read only open custcursor set @count=0while (1=1) begin Fetch Next from CustCursor into @Superior,@CountNum print @Superior print @countNum if(@@FETCH_STATUS <>0) begin print 'break' break; end select * From [stuff] where superior=@Superior Set @count=@count+1 end close custcursor deallocate custcursorGO 这是我的SQL语句我如何在TADOQuery中选择使用那个数据集
我建议你,别使用ADODataSet,使用ADOQuery,或使用ADOTable
这样很多东西都可以控制。
别使用ADODataSet,使用ADOQuery,或使用ADOTable
declare @Superior varchar(20)
declare @countNum int
declare CustCursor Cursor for
select superior,count(superior) as RecordeCount
from [stuff]
group by Superior
for read only
open custcursor
set @count=0while (1=1)
begin
Fetch Next
from CustCursor
into @Superior,@CountNum
print @Superior
print @countNum
if(@@FETCH_STATUS <>0)
begin
print 'break'
break;
end
select * From [stuff]
where superior=@Superior
Set @count=@count+1
end
close custcursor
deallocate custcursorGO
这是我的SQL语句我如何在TADOQuery中选择使用那个数据集