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);
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
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)
FROM OPENROWSET(BULK N'D:\Files\Entertainment\Pictures\1.JPG', SINGLE_BLOB) AS P;
No one has followed this question yet.
Gender count for employees based on experience in incremental order
T-sql restore and transactions
Installing SQLServer 2008 express and Studio Management
SQL Group by query - needs your attention
Running xp_cmdshell as Administrator