Insert image into table using sql statement | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Insert image into table using sql statement

Hi is it possible to insert blob in sql using only sql statement?
thank you
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. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

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
http://www.insidesql.de
http://www.familienzirkus.de
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. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>