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

in mssql2000, could not update column

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