ADO循环语句如何转成sql语句

ADO循环语句怎么转成sql语句

C/C++ code

        RxRecordset rst;        sql="select * from A";    rst.Open(sql);    while(!rst.end())    {        int Id=atoi(rst.GetFieldValue("Id"));        RxRecordset rs;        sql.Format("select top 100 * from %s where Id >= %d and Id<%d",B,Id*100,Id*100+99);        rs.Open(sql);        while(!rs.isend())        {           rs.MoveNext();        }        rst.MoveNext();    }