Ms SQL 2000 support
| User, date | Message |
|---|---|
|
Written by matrik
10 months ago Category: General 1 posts since Thu, 05 Jul 12 |
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. |
|
Written by richard
3 months ago 6 posts since Tue, 15 Aug 06 |
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) |
|
Written by ansgar
3 months ago 3950 posts since Fri, 07 Apr 06 |
Could you please update your HeidiSQL to the latest build? I'm not sure but I think I had fixed that some time ago. This thread is old. |
|
Please login to leave a reply, or register at first. |