페이징 기법. DECLARE @PageSize TINYINT = 20, @CurrentPage INT = 1500; WITH o AS ( SELECT TOP (@CurrentPage * @PageSize) [RowNumber] = ROW_NUMBER() OVER (ORDER BY SalesOrderID), SalesOrderID /* , ... */ FROM Sales.SalesOrderHeader ) SELECT SalesOrderID /* , ... */ FROM o WHERE [RowNumber] BETWEEN ((@CurrentPage - 1) * @PageSize + 1) AND (((@CurrentPage - 1) * @PageSize) + @PageSize) ORDER BY [RowNumbe..
MSSQL
Option name in the popup list Inserted string (where Fld is the selected field) Float [6-digit] CONVERT(VARCHAR, Fld, 0) Float [8-digit Scientific] CONVERT(VARCHAR, Fld, 1) Float [16-digit Scientific] CONVERT(VARCHAR, Fld, 2) Other Numeric CONVERT(VARCHAR, Fld) Currency [9999.99] CONVERT(VARCHAR, Fld, 0) Currency [9,999.99] CONVERT(VARCHAR, Fld, 1) Currency [9999.9999] CONVERT(VARCHAR, Fld, 2) D..
