How to import images from folder to SQL server.

nn 20 Reputation points
2024-07-03T04:37:15.3466667+00:00

How to import images from folder to 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.
14,452 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 45,881 Reputation points
    2024-07-03T04:53:33.4566667+00:00

    A vague question, so a vague answer:

    You can use the OPENROWSET (Transact-SQL) function with option "BULK" + "SINGLE_BLOB", see

    https://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver16

    0 comments No comments

  2. LiHongMSFT-4306 30,666 Reputation points
    2024-07-04T01:43:51.94+00:00

    Hi @nn

    You could use T-SQL code.

    See this article for more details: Simple Image Import and Export Using T-SQL for SQL Server.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.