INF: Display Limitations for TEXT or IMAGE Columns

MORE INFORMATION

Sample Table Schema

   create table text_tbl
   (
     textstring text null,
     tid int                -- some unique record ID
   )
				

Loop to Retrieve TEXT Data Out in Chunks of 250 Characters

   declare @txt_ptr   varbinary(16), -- Pointer to TEXT data
           @txt_len    int,          -- Remaining TEXT data length thru

   each loop

           @txt_offset int,          -- Offset into TEXT data
           @txt_chunk  int           -- Length of TEXT data retrieved thru

   each loop

   -- Retrieve pointer to TEXT data
   select @txt_ptr=textptr(textstring) , @txt_len=datalength(textstring)
     from text_tbl
     where tid=2

   -- Initialize loop parameters
   select @txt_offset=0,@txt_chunk=250

   while @txt_len > @txt_chunk
   begin
   readtext text_tbl.textstring @txt_ptr @txt_offset @txt_chunk
    select @txt_offset = @txt_offset + @txt_chunk, @txt_len = @txt_len -

   @txt_chunk
   end

   -- Retrieve remaining TEXT data
   readtext text_tbl.textstring @txt_ptr @txt_offset @txt_len