PHP Classes

SQL Query

Recommend this page to a friend!

      PHP-MYSQL-MSSQL  >  All threads  >  SQL Query  >  (Un) Subscribe thread alerts  
Subject:SQL Query
Summary:Not support for MsSql SQL Query Language
Messages:2
Author:Leonardo Volinier
Date:2007-05-16 20:15:54
Update:2012-07-11 05:16:11
 

  1. SQL Query   Reply   Report abuse  
Picture of Leonardo Volinier Leonardo Volinier - 2007-05-16 20:15:54
The construction of the SELECT Query is wrong. MsSQL servers doesn't support the "LIMIT" property.

An aproximation is the "TOP N" property (where N is the number of records from the top) after SELECT word.

One solution is working with temptables.

But "naturally" you can't make a page cut at MsSql.

  2. Re: SQL Query   Reply   Report abuse  
Picture of anshul anshul - 2012-07-11 05:16:11 - In reply to message 1 from Leonardo Volinier
I am getting ror: Call to undefined function mssql_pconnect() .

What I need to do ?