Read File Content As Binary VIA SqlServer Query

DECLARE @FILEPATH NVARCHAR(255) = 'D:\TEST.PNG';
DECLARE @CMD      NVARCHAR(MAX);
DECLARE @FILEDATA VARBINARY(MAX);

SET @CMD = N'SELECT @FILEDATA = (SELECT * FROM OPENROWSET(BULK N''' + @FILEPATH + ''', SINGLE_BLOB) AS CONTENTS)';
EXECUTE SP_EXECUTESQL @CMD, N'@FILEDATA VARBINARY(MAX) OUTPUT', @FILEDATA OUTPUT;

SELECT @FILEDATA;