distal-attribute
distal-attribute
distal-attribute
distal-attribute

in mssql2000, could not update column

User, date Message
Written by pqwer99
12 months ago
Category: General
2 posts since Wed, 28 Aug 13
in mssql2000, could not update a column.
UPDATE TOP(1) tb SET "zb"=411 WHERE "rq"='2012-01-19' AND "zb"=41;
SQL Error (156),near TOP
Written by ansgar
12 months ago
4962 posts since Fri, 07 Apr 06
Seems Microsoft introduced TOP(x) for UPDATES and DELETED in MSSQL 2005. Sigh...
Written by ansgar
12 months ago
4962 posts since Fri, 07 Apr 06
r4495 leaves that TOP(x) clause away from the UPDATE query. Makes it slightly more unsafe, unless you have primary or unique keys in your tables.
 

Please login to leave a reply, or register at first.