Insert/Update to Text datatype fields : LUSENET : SQL Server Database Administration : One Thread

Is there any way to update/insert data into tables that contain a text dayatype column without the hassles of UPDATETEXT? I would prefer to use standard SQL syntax.

-- Anonymous, October 16, 2001



I don't think so. An alternative is the split the value into multiple varchar values and store these in a separate table, kind of like an array. In this case, the table would contain ID (FK to primary table), LineNumber, TextValue columns.

Hope this helps,


-- Anonymous, October 23, 2001

Moderation questions? read the FAQ