Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to load up a photo from a file:

-- T-SQL upload image into database - import photo into database table

USE AdventureWorks;

INSERT Production.ProductPhoto

      (ThumbnailPhoto,

       ThumbnailPhotoFilePath,

       LargePhoto,

       LargePhotoFilePath)

SELECT ThumbnailPhoto.*,

       NULL,

       NULL,

       N'mountainkingsmall.gif'

FROM   OPENROWSET(BULK 'd:\data\images\mountainking.jpg',SINGLE_BLOB)

       ThumbnailPhoto