USE Arm_DB GO IF OBJECT_ID('TBL_Image','U') IS NOT NULL DROP TABLE TBL_Image CREATE TABLE TBL_Image ( [ID] INT IDENTITY(1,1) ,[Image] VARBINARY(MAX) CONSTRAINT PK_TBL_Image PRIMARY KEY CLUSTERED (ID) ) Go INSERT INTO TBL_Image(Image) SELECT * FROM OPENROWSET(BULK 'C:\Users\Public\Pictures\Sample Pictures\Koala.JPG',SINGLE_BLOB ) i