Hi!
I'm using HeidiSQL for connection to MS SQL 2000 Server.
When I'm editing datas in SQL-query program generate sql-update query with TOP command
For example:
UPDATE TOP(1) "Blabla" SET blabla ...
Unfortunately TOP command is not supported in MS SQL 2000 Server.
If I manualy delete word TOP from updating query all works perfectly.
Is it possible to add option for MS SQL server 2000, which allows to remove TOP from UPDATE command?
Thank.
Ms SQL 2000 support
We have the same Problem, so HeidiSQL ist not useable for SQL Server 2000.
SELECT @@Version
---------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
SELECT @@Version
---------------------------------
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Please login to leave a reply, or register at first.