Estoy migrando mi web de Mysql A MsSql y
Tengo este código
Código PHP:
mssql_select_db($database_conectionx, $conectionx);
$query_Recordset1 = "SELECT SUM([potential revenue]) AS 'TOTAL' FROM quotex WHERE [annual revenue] = 'More than $12 M less than $50 M' AND [average response time] =2008";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mssql_query($query_limit_Recordset1, $conectionx);
$row_Recordset1 = mssql_fetch_assoc($Recordset1);
...con los siguientes errores
Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near 'LIMIT'. (severity 15) in C:\wamp\www\quotesite2\2008\+13.php on line 31
Warning: mssql_query() [function.mssql-query]: Query failed in C:\wamp\www\quotesite2\2008\+13.php on line 31
Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\wamp\www\quotesite2\2008\+13.php on line 32
Supongo que es la sintaxis de LIMIT, creo que lo que podría utilizar es TOP pero no tengo idea de cómo...alguien podría ayudarme?
URGE, grax!