UPDATETEXT on memory tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paulo Morgado (paulo.morgado_at_nospam.pt)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 02:39:53 -0800

Hi all

I need to add text to a text column in a temporary table.

I thougth of using an in memory temporary table (declare
@tmp_tab table ...)

I have no problem with:
select @ptr = TEXTPTR(text_column) from @tmp_tab where
<cond>

But, when I use:
UPDATETEXT @tmp_tab.text_column @ptr null null @text

I get:
Server: Msg 170, Level 15, State 1, Line 97
Line 97: Incorrect syntax near '@tmp_tab'.

Can't I use UPDATETEXT on memory tables?

TIA
Paulo Morgado

Relevant Pages

  • Re: Adding text string to TEXT data type ??
    ... You will need to declare a varbinaryvariable to hold a pointer to the ... Then use updatetext to insert or append text. ...
    (microsoft.public.sqlserver.programming)
  • Re: `volatile on local variable used outside of function
    ... Do I then have to declare `i' ... as `volatile' to get the expected behavior? ...
    (comp.lang.c)
  • Re: why does a change?
    ... char* ptr; ... You have declared a as int and ptr as pointer to char. ... If you declare ptr as pointer to int or declare a as char then things ...
    (comp.lang.c)
  • Re: why does a change?
    ... char* ptr; ... You have declared a as int and ptr as pointer to char. ... If you declare ptr as pointer to int or declare a as char then things ...
    (comp.lang.c)
  • updatetext and table variable
    ... i want to update a column of a table variable (@tablename) with 'updatetext'. ... DECLARE @tempTable table (data ntext) ... UPDATETEXT @tempTable.data ... ...
    (microsoft.public.sqlserver.server)