Inserting a JPG in a image field 1

[josesc]

I don't have many experience with Sql server and I want to know how I can insert a JPG picture in a image field only using SQL language in other words only using the Query Analyzer.

 

[tlbroadbent]

You can use batch programs to load images or use the WRITETEXT and UPDATETEXT Transact-SQL (T-SQL) statements to insert them into SQL Server. SQL Server Books Online (BOL) includes code samples with the references for those statements.

If transactional consistency doesn't matter, or can be achieved programmatically, then it is easier to store the image outside the database as an ordinary file. Within the database just hold a UNC pointer to the file. This makes it easier to display/edit the data as the name can simply be passed to whatever tool is doing the manipulation.

Check out these articles for more info.

http://www.mssqlserver.com/faq/development-imagetext.asp

http://support.microsoft.com/support/SQL/Content/inprodhlp/_writetext.asp

http://support.microsoft.com/support/SQL/Content/inprodhlp/_updatetext.asp

http://msdn.microsoft.com/library/psdk/sql/ac_8_qd_13_8orl.htm

Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost