Insert/Update to Text datatype fieldsgreenspun.com : 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