PHP Datagrid and SQL Express

Talk about working with different database types

Moderator: alexandrleonenko

Site Admin
Site Admin
Posts: 6028
Joined: Jan 7th, '09, 23:18

Re: PHP Datagrid and SQL Express

Postby administrator » May 19th, '10, 09:11

PHP DataGrid works with MSSQL 2005 or later

The SQL for MSSQL transformed into following (example)

Code: Select all

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

Return to “Databases: different types implementation”