how to upload blob into a variable for Image / VarBinary(max) columns

interesting method for uploading a single blob into sql server using variables 🙂

DECLARE @DummyDoc AS varbinary(max)
SET @DummyDoc = (SELECT * FROM OPENROWSET(BULK N’D:ScriptsAWARE_TeamRoster.xls’, SINGLE_BLOB) AS NewDoc)