PHP Datagrid and SQL Express

Talk about working with different database types

Moderator: alexandrleonenko

administrator
Site Admin
Site Admin
Posts: 6011
Joined: Jan 7th, '09, 23:18
Contact:

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 * 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


Return to “Databases: different types implementation”