SQLServer Text to Image

• NeoNash

  SSC Eights!

  Points: 914

  More actions

  April 18, 2002 at 7:43 pm

  #158358

  I have two tables.

  Test1 (value TEXT) and Test2(value IMAGE)

  I need to transfer data from Test1 to Test2.

  Please let me know how I can do this with T-SQL. I can not use JAVA or some other language in this place. It has to be simple script which will directly run in SQL Query analyzer.

  Thanks for your help.

  Edited by - NeoNash on 04/18/2002 7:52:40 PM

• NeoNash

  SSC Eights!

  Points: 914

  More actions

  April 18, 2002 at 8:20 pm

  #427460

  OK. I found a way. But I guess it must have some limitations.

  Assuming only one record in Test1.

  Test1

  'This is my first value'

  Test2 is empty.

  Code:

  declare

  @a varchar(8000)

  begin

  select @a = value from Test1

  update Test2 set value = @a

  end

  go

  I tested the otherway to convert back IMAGE to TEXT using JAVA the TEXT message is transfered OK.

  Any limitations - I have to digin more.

  If you have more to share please let me know.

  Thanks,

  NeoNash