I'm trying to insert an image into the database.
CREATE TABLE ImageTable
(
Id int,
Name varchar(50) ,
Photo varbinary(max)
)
INSERT INTO ImageTable (Id, Name, Photo)
SELECT 10, 'John', BulkColumn
FROM Openrowset( Bulk 'C:caldophilus.jpg', Single_Blob) as EmployeePicture
It throws me an error.
Cannot bulk load. The file "C:caldophilus.jpg" does not exist.
Please Help.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…