Query to convert http link for an image to varbinary format.

CREATE TABLE DBFiles (
  id int IDENTITY(1,1) NOT NULL,
  fname nvarchar(1000) NOT NULL,
  [file] varbinary(max)
)

INSERT INTO DBFiles(fname, [file]) 
SELECT 'Wallpapers', * FROM OPENROWSET(
  BULK N'https://s3.amazonaws.com/proxio-1/2009-08-08/ec225927-05f6-48cb-8a82-60056e636cc3',
  
  SINGLE_BLOB
) rs;