import/export BLOB

http://blog.rptea.com/post/Simple-scripts-to-insert-File-to-BLOB-field-and-export-BLOB-to-File-system.aspx

CREATE TABLE [dbo].[TmpBin](
     [MyId] [int] IDENTITY(1,1) NOT NULL
   , [MyDesc] [varchar](50) NULL
   , [MyBin] [varbinary](max) NULL ) 
ON [PRIMARY] 

INSERT INTO (MyDesc, MyBin) 
Select 'MyDesc01' 
   , BulkColumn from Openrowset( Bulk 'C:\temp\image1.jpg', Single_Blob) as tt 

Insert TmpBin(MyDesc, MyBin) 
Select 'MyDesc02' 
, BulkColumn from Openrowset( Bulk 'C:\temp\image2.jpg', Single_Blob) as tt

INSERT INTO TmpBin(MyDesc, MyBin) 
SELECT 'MyDesc03' 
     , BulkColumn 
FROM Openrowset( Bulk 'C:\temp\image3.jpg', Single_Blob) as tt