How to store URL link into Image in column in table

Question

How to store URL link into Image in column in table

Shanvitha 221

Hi Sql server team,

I have logos store in Azure Blob( I have URL link and also I have access download and upload)

I need Store those URL logo in Azure sql databse( i need create new table)

Pleas help how to store the in URL logo in Column

Thanks
Shanvitha

Magnus Ahlkvist 76 Reputation points MVP

2020-10-20T11:09:36.71+00:00

I would advice to store only the filename or possibly a foldername/filename in the table, and to get the URL to the container from either an application config file or from another table. That way, you can switch to another container at any time without updating the table with the paths to the files.

To be able to suggest a table design for the new table or tables, you need to tell us more. How will you query the database for this information? Will you use the filename to search, or is there a relation to some other information already stored in the database, where you need to make a lookup of the logo for a specific entity?

Accepted answer

2 additional answers

Your answer

Magnus Ahlkvist 76 Reputation points MVP

2020-10-20T11:09:36.71+00:00

I would advice to store only the filename or possibly a foldername/filename in the table, and to get the URL to the container from either an application config file or from another table. That way, you can switch to another container at any time without updating the table with the paths to the files.

To be able to suggest a table design for the new table or tables, you need to tell us more. How will you query the database for this information? Will you use the filename to search, or is there a relation to some other information already stored in the database, where you need to make a lookup of the logo for a specific entity?

Answer 1

MelissaMa-MSFT 24,221

Hi @Shanvitha ,

Please refer with below code and check whether it is helpful to you.

CREATE TABLE [dbo].[SFMC_HTML_Images](  
    [HTML_Image] varbinary(max) NULL,  
    SendID varchar(50) null  
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]  
GO  
  
Insert into SFMC_HTML_Images (HTML_Image)   
Select BulkColumn FROM OPENROWSET(   
BULK '4017033.jpg',   
DATA_SOURCE = 'MyAzureBlobStorage', SINGLE_BLOB) AS ImageFile;

You could refer more details from below:
How to insert image file, stored in Azure blob storage, into an Azure SQL table

Best regards
Melissa

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator

2020-10-21T06:57:13.21+00:00

Only to add to Melissa's post, here is also a link with some details. I tried to follow it myself last night, but I ran out of time: https://learn.microsoft.com/en-us/sql/relational-databases/import-export/examples-of-bulk-access-to-data-in-azure-blob-storage?view=sql-server-ver15

Answer 2

Shanvitha 221

Hi MagnusAhlkvist ·/Sql server export,

I need store URL logo as image format in the table.

please store Image format in the table given AZURE BLOB URL

Thanks
Shanvitha

Magnus Ahlkvist 76 Reputation points MVP

2020-10-20T12:10:30.087+00:00

Ok, so before going into code, I just want to be sure I understand the requirements:

You have a logo stored in an Azure blob that you have the url to, and you want to create a new table in a sql database and store the actual logo in the database, and you want help with code that will get the logo from the URL and store it a varbinary(max) column in a table?

Answer 3

Shanvitha 221

Hi MagnusAhlkvist,
thank you replay.
yes your correct understand.
please suggest how to write query. or help me sample query.

Thanks
Shanvitha

Share via

How to store URL link into Image in column in table

2 additional answers

Your answer