SQL Server Performance Forum – Threads Archive
Insert image into table using sql statementHi 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 http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm Chris
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 Frank
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. _________