SQL Server Performance

Insert image into table using sql statement

Discussion in 'General DBA Questions' started by NewDBA, Nov 19, 2003.

  1. NewDBA Member

    Hi is it possible to insert blob in sql using only sql statement?
    thank you
  2. ChrisFretwell New Member

  3. satya Moderator

    TO deal with use READTEXT/WRITETEXT/UPDATETEXT and refer to books online for more information.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  4. FrankKalis Moderator

  5. NewDBA Member

    textcopy.exe is exactly what i need ,but cannot make it working

    Have a question /F (file name) is a path to file ritgt?
    I do not put anything in /W (where clause)

    Details: i created the table with one field a (text)
    anf try to insert there .rft file.

    what i miss?
  6. satya Moderator

Share This Page