CREATE TABLE BLOBTest ( BLOBID int IDENTITY NOT NULL, BLOBData varbinary(max) NOT NULL ) GO INSERT INTO BLOBTest(BLOBData) SELECT * FROM OPENROWSET(BULK N'D:\DSN0022.jpg', SINGLE_BLOB);
asked
What is wrong in this code!
The problem is that you did not specify an alias for the OPENROWSET. Use this insert instead of yours (just added alias):
INSERT INTO BLOBTest(BLOBData)
SELECT *
FROM OPENROWSET(BULK N'D:\Files\Entertainment\Pictures\1.JPG', SINGLE_BLOB) AS P;
