Upload file to SQL server into varbynary(max) using SQL Server function OPENROWSET and BULK

Insert_BLOB_from file.txt

CREATE TABLE myTable(FileName nvarchar(60),
  FileType nvarchar(60), Document varbinary(max))

  INSERT INTO myTable(FileName, FileType, Document)
   SELECT 'ConnectionManager.pdb' AS FileName,
      '.pdb' AS FileType,
      * FROM OPENROWSET(BULK N'D:\TEST\BIN\ConnectionManager.pdb', SINGLE_BLOB) AS Document

You can use DATALENGTH() function to determine the length of the column content:

select DATALENGTH(Document),Document from myTable where FileName='ConnectionManager.pdb'

The VARBINARY(MAX) field allocates variable length data up to just under 2GB in size.