I want to read xml data from mssql table and save it to file.
The xml file is stored in a ntext column table. I have a query to which returns the rows with ntext column. There is a datalength in bytes in another column. All i need is dump the xml file stored in the ntext column table to a xml file in a specied folder.
The table is a mssql table. It would be great if anyone can get me output using tsql my prefered option.
But anyother fast methods is acceptable if i can maintain the query easily.
Xml file is stored in a ntext column. I just want to retrive it and save it to file.
I am sharing the db backup . http://jmp.sh/v/50SqZPDFt40j4oHTQZjR
DocumentData is a ntext column which needs to be extracted to file
26 freelancers are bidding on average ₹7199 for this job
Hello It looks as easy project can be completed in few hours of pure working time Also, I have installed MSSQL Server on my machine. and I have experience with SQL and MSSQL particularly
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8 years and 5 months experience in SQL. Please let me know more details and when we will start. Sky pe jikenjd