Поделиться через

Storing Images and BLOB files in SQL Server...

  • Статья

This is a serie of 4 interesting articles discussing better ways to handle BLOB with SQL Server.

Part 1  https://www.databasejournal.com/features/mssql/article.php/3719221
           where definitions are given and where you will find a pointer to a search article : To BLOB or Not To BLOB
Part 2      https://www.databasejournal.com/features/mssql/article.php/3724556
 

where you will find how to insert a BLOB directly in the Database :

 INSERT INTO BLOBTest (BLOBName, BLOBData) SELECT 'First test file',     BulkColumn FROM OPENROWSET(    Bulk 'C:\temp\nextup.jpg', SINGLE_BLOB) AS BLOB
Part 3 https://www.databasejournal.com/features/mssql/article.php/3732256
  where you will build a sample application to upload  the BLOB :
Part 4 https://www.databasejournal.com/features/mssql/article.php/3738276
  where the application is completed :

 

image