您當(dāng)前所在位置：首頁(yè) → 數(shù)據(jù)庫(kù) → MSSQL → 初學(xué)者必讀：經(jīng)典的數(shù)據(jù)庫(kù)記錄分頁(yè)代碼

初學(xué)者必讀：經(jīng)典的數(shù)據(jù)庫(kù)記錄分頁(yè)代碼

方案:◆1、SELECT TOP PAGESIZE NEWSTITLEFORM NEWSINFO WHERE NEWSID NOT IN(SELECT TOP (PAGE-1)* PAGESIZE NEWSID FROM NEWSINFOWHERE Auditing=1 and

網(wǎng)友評(píng)論