quote:

---

Originally posted by robvolk

INSERT INTO tablename (column_name) SELECT column_name FROM column_name FROM OPENROWSET(BULK N'path_of_image', SINGLE_BLOB) AS tt(column_name)

---

INSERT INTO tablename (column_name1,columnname2,imagecolumn) 
SELECT value1,value2,
(SELECT * FROM OPENROWSET(BULK N'Image Path Here', SINGLE_BLOB)as u)

for latter use just an update like

UPDATE t
SET t.ImageCol= (SELECT * FROM OPENROWSET(BULK N'ImagePathHere', SINGLE_BLOB)as u)
FROM Table
WHERE...

quote:

---

Originally posted by visakh16

for multiple columns use

INSERT INTO tablename (column_name1,columnname2,imagecolumn) 
SELECT value1,value2,
(SELECT * FROM OPENROWSET(BULK N'Image Path Here', SINGLE_BLOB)as u)

for latter use just an update like

UPDATE t
SET t.ImageCol= (SELECT * FROM OPENROWSET(BULK N'ImagePathHere', SINGLE_BLOB)as u)
FROM Table
WHERE...

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---