Showing posts with label Add image in the SQL Table. Show all posts
Showing posts with label Add image in the SQL Table. Show all posts

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