hi all,
i have created a table with image field in it. Now i just want to store a jpeg file in it but not finding any way to do so.
how can i store any image ? what are the steps?
thanx in advance
Actually, the following statement will only work in sql2005. Sorry.
Try something like this:
Code Snippet
create table #bob
(id int, jpeg image)
insert into #bob
select 1, bulkcolumn
from openrowset(BULK 'c:\Winter.jpg', SINGLE_BLOB) AS table
HTH
|||how to add using enterprise manager. I don't want to create a stored procedure for that or any sql statement.
Can i directly insert image as i can enter text into any text field?
|||I don't think you're able to add them in via EM.
I think you can use textcopy (see Books Online) and there shouild an example of how this works in the pubimage.bat file in your install directory c:\program files\microsoft sql server\mssql\install\
HTH.
|||No way to do this in SSSM or EM.If you favour doing this in SSMS in the next version of SQL Server, feel free to post a connect bug / feature request in the connect forums at www.connect.microsoft.com.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
