Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
azerbaycanli113
Starting Member
5 Posts |
 Posted - 2010-10-29 : 06:47:48
|
| Hi there. I was wondering if there's anyway I can store any large, particularly binary data in an XML file and be able to retrieve it whenever I need. Maybe something like actual file in an XML file but the address in MS SQL table column.If not that then anything that'd ease table load. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-10-29 : 07:13:32
|
If you convert the binary data to BASE64 it should be ok.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
azerbaycanli113
Starting Member
5 Posts |
Posted - 2010-10-29 : 07:36:59
|
| Tank you for your reply. But, can you show me how to do it? Cuz I've never done this before and got no idea.How am I going to save only binary fata in an XML file when pressing post button in dbnavigator and the rest data to MS SQL table columns? WHen am I going to convert the file to Base64? |
|
|
|
|
|
|
Binary Data in an XML file