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

in mssql2000, could not update column

User, date Message
Written by pqwer99
11 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
11 months ago
4936 posts since Fri, 07 Apr 06
Seems Microsoft introduced TOP(x) for UPDATES and DELETED in MSSQL 2005. Sigh...
Written by ansgar
11 months ago
4936 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.