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

in mssql2000, could not update column

pqwer99 posted 2 years ago in General
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
ansgar posted 2 years ago
Seems Microsoft introduced TOP(x) for UPDATES and DELETED in MSSQL 2005. Sigh...
ansgar posted 2 years ago
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.