when i run this query ......
update item set description=(se lect description from item where itemid=5384);
i get this error message...
Msg 279, Level 16, State 3, Line 1
The text, ntext, and image data types are invalid in this subquery or aggregate expression.
there is a lot of text in the description column of itemid 5384 (html coding) and i need to set all of the records in the...
User Profile
Collapse
-
error Msg 279, Level 16, State 3
-
update using data from table
my item table looks like this:
itemID name description
1 coin1 good coin
24 coin2 bad
35 coin3 bad
48 coin4 bad
i need to use the description in row one to update the other records to read the same as row 1
it would then look like this...
itemID name description
1 coin1 good coin
24...
No activity results to display
Show More