Discussion in 'General DBA Questions' started by NewDBA, Nov 19, 2003.
Hi is it possible to insert blob in sql using only sql statement?
Sort of. You use the MS provided textcopy.exe, C++ program. But you can execute it from sql.
There is a good example at
TO deal with use READTEXT/WRITETEXT/UPDATETEXT and refer to books online for more information.
And after you have played around with READTEXT.... you might come to the solution that the ADO Stream Objewct is by far easier to handle, IMHO
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?
Can take help from thishttp://www.databasejournal.com/features/mssql/article.php/1443521 link.
Separate names with a comma.