摘要:
if giPage = 1 then begin sSQL := 'SELECT TOP 10 * FROM dw_demo WHERE '+sWhere +' ORDER BY '+sOrder+' DESC'; end else begin sSQL := 'select top 10 * fr 阅读全文
摘要:
以下是SQL SERVER 分页的代码,供参考(主要是自己下次用时参考) sSQL := 'SELECT TOP 10 * FROM dw_demo WHERE id NOT IN (' +'SELECT TOP '+((giPage-1)*10).ToString+' id FROM dw_dem 阅读全文