question

LMBUX avatar image
LMBUX asked

Can you generate xml feeds in ssms with images/pictures

I am designing my database to hold records of user profiles. These user profiles have the standard: title, name, biography and each have a picture which I need save in the table also Title Name Biography Image I need to generate an XML output for the web developer to use in the website, is it possible to send this image in the XML or will he need these picture in a location he can access? Hope this makes sense. Thanks, Lauren
xmlssmsasp.netimageswebinterface
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
0 Likes 0 ·

1 Answer

·
LMBUX avatar image
LMBUX answered
Hi, thanks for getting back to me, after reading this still have some questions. The image will be stored within the table in the sql database. The web developer has asked for xml feeds, I am going to generate xml feeds via sql query. Is it not best to store the images in a sql table but instead in a directory? User will be uploading their images through a web portal.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.