select @MimeType,BulkColumn from Openrowset(Bulk @image , Single_Blob) as EmployeePicture

| BULK 'data_file' ,

{ FORMATFILE = 'format_file_path' [ <bulk_options> ]

| SINGLE_BLOB | SINGLE_CLOB | SINGLE_NCLOB }

Have a look: http://msdn.microsoft.com/en-us/library/ms190312.aspx