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
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.