Monday, December 6, 2010

Add image in the SQL Table

Create table ImageDB (description varchar(20), img image)
insert into ImageDB (description, img)
(
Select 'description1234', *
from OPENROWSET(BULK N'C:\Users\Public\Pictures\Sample Pictures\Desert.jpg', SINGLE_BLOB) as tempImg
)

Select * from ImageDB