diandian82的专栏

假设共有18(TotalRowNum)条数据，PageSize设为5 SELECT TOP 5 * FROM      (SELECT TOP 5 * FROM               (SELECT TOP 15 ID, Title, Detail, CreateTime FROM BusinessInfo ORDER BY CreateTime DESC, ID ASC)     --

<br />In this code, you can pass parameters to the connection and refresh it, the pivot table in the excel will get updated. It is very useful when developing the excel reports.<br /> <br />Sub ToRefreshPivot() Dim Alias As String 'Alias =