PHP Datagrid and SQL Express

[administrator]

PHP DataGrid works with MSSQL 2005 or later

The SQL for MSSQL transformed into following (example)

Code: Select all

      SELECT * FROM
      ( SELECT TOP 10 ROW_NUMBER() OVER ( ORDER BY name ASC, statuspa DESC) AS RowNumber, demo_development.id FROM demo_development WHERE 1=1 ) as foo
      WHERE 1=1 AND (RowNumber > 0 AND RowNumber <= 10)
      ORDER BY name ASC, statuspa DESC