Share via

How to import images from folder files to SQL server?How can we see full image on SQL server.

Anandhswarupp 20 Reputation points
2024-07-06T12:38:50.8666667+00:00

How to import images from folder files to SQL server?How can we see full image on SQL server.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,208 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 105.8K Reputation points MVP
    2024-07-06T12:47:41.6833333+00:00

    First of all, you cannot see any images in (or on) SQL Server, of the simple reason that SQL Server does not have a user interface. You can store images in SQL Server, but you need an application to display them.

    Typically, you would also use an application to load the images into SQL Server, just like you would store any other data. Although, there are a few more variations for LOB data. You can store it as Filestream, or you can even use a FileTable. In both cases, the images are stored as files. With Filestream in general, that is still entirely within the database and not visible elsewhere. With FileTable, you can access the files through the Windows Explorer or similar means.

    I happen to have a very old sample on how to load blobs with VB6 here: https://www.sommarskog.se/blobload.txt

    0 comments