1
Reply

inserting image

aditya immadi

aditya immadi

Jul 11 2013 2:45 AM
1k
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



Answers (1)