January 23rd, 2004, 02:01 AM
UPDATETEXT and Table data type?
Can anyone tell me whether UPDATETEXT works with the table data type? I've got this line of code :
UPDATETEXT @TEMPTABLE.TEXTFIELD @PTRVAL @POS 1 'AHAHAHAHAH'
but I get the error :
Incorrect syntax near '@TEMPTABLE'
It works with a 'real' temp table but I don't want the overheads, this need to be quick. Anyone done this or got any ideas of a way around it?
January 23rd, 2004, 09:39 AM
I can answer this myself - table data type doesn't work in this context.