I have a query that works well with postgreSQL
I just uploaded the code to a SQL Server installation and this query is failing with
the Error:
---
Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near 'LIMIT'.
SQL = SELECT *
FROM SPCData, Device
WHERE
17, 2002 11:29 PM
Subject: Need quick SQL Server Advice
I have a query that works well with postgreSQL
I just uploaded the code to a SQL Server installation and this query is
failing with the Error:
---
Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near
SELECT TOP 8 *
FROM SPCData, Device
WHERE SPCData.SPCDitem_ID = 1
AND SPCData.SPC_Device_ID = Device.Device_ID
ORDER BY SPCData_ID DESC
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.375 / Virus Database: 210 - Release
Paul, Doug Thanks!
At midnight things get blurry
At 11:48 PM 7/17/02, you wrote:
SELECT TOP 8 *
FROM SPCData, Device
WHERE SPCData.SPCDitem_ID = 1
AND SPCData.SPC_Device_ID = Device.Device_ID
ORDER BY SPCData_ID DESC
---
Outgoing mail is certified Virus Free.
Checked by AVG
4 matches
Mail list logo