inserting image

aditya immadi

Hai all,
i need to insert multiple images in sql .table columns are name and image .

 INSERT INTO images SELECT * FROM OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB) rs

with this statement i can insert single image(in the case table has single row only)

now i need to insert name and image i have 300 records ..can any one help me out

Thannks and Regards

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Hi,
You will be not able to do by using single insert command. You can try like this

DECLARE @imgString varchar(80)
DECLARE @insertString varchar(3000)

SET @imgNumber = 1
WHILE @imgNumber < 301
BEGIN
SET @imgString = 'C:\Image' + CONVERT(varchar,@imgNumber) + '.jpg'
SET @insertString = N'INSERT INTO images(imageData)
SELECT * FROM OPENROWSET(BULK N''' + @imgString + ''', SINGLE_BLOB) as tempImg'
EXEC(@insertString)
SET @imgNumber = @imgNumber + 1
END
GO

Regards,
Iftikar
0