appending an ntext field
Say you want to do something like this:
update table set ntextThing = ntextThing + '!' where id = 1
That's not going to work. This does, though:
DECLARE @ptrval binary(16)
SELECT @ptrval = TEXTPTR(ntextThing)
FROM item
WHERE id =1
UPDATETEXT table.ntextthing @ptrval NULL 0 '!'
GO
SELECT @ptrval = TEXTPTR(ntextThing)
FROM item
WHERE id =1
UPDATETEXT table.ntextthing @ptrval NULL 0 '!'
GO
There are no comments for this entry.
[Add Comment]