How to insert a file as a XML in sqldatabase table

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Hi i Have a File i want to store the file in the format of xml , which can access or load from Database when it is required , any One help me with sql server code , it saves me lot of time and codeing for my developemnt project should be like

What I have tried:

Hi Have a File i want to store the file in the format of xml , which can access or load from Database when it is required , any One help me with sql server code , it saves me lot of time and codeing for my developemnt project

Posted 27-Jan-21 2:00am

saagarchary

Updated 27-Jan-21 5:44am

Add a Solution

Comments

RedDk 27-Jan-21 12:05pm

Consult the help document for your root installation. That's the "Book On Line" which has to be obtained from MS. Lookup "XML". Read about all things TSQL in that "BOL".

You know, once you code something to do something and it works as you want it to work, you can save that code, make copies of it, store the copies ... then after you build up a store of code that works ... even search through it usg keywords that are found in that BOL, you're all set. You don't have to code again. So you're efforts become you're own answers.

Once you write some code and it works, you never have to do anything with it. Not even "know" what it was you did in the first place: just look the keyword up in your storage and determine whether something you wrote is suitable to use in your new procedure/method/function/etc.

Fantastic or what?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2021-01-27T02:10:00

Solution 1

You can save it to disk and store its address in the database. Or, if it is not too large just store it in a varchar field.

Posted 27-Jan-21 2:10am

Richard MacCutchan

Comments

saagarchary 27-Jan-21 8:33am

can u please post the sql query

Richard MacCutchan 27-Jan-21 9:11am

What query?

OriginalGriff · Answer 2 · 2021-01-27T02:13:00

If you mean you want to store an XML file in a single column of a row in an SQL table, then just pass it via a parameterized query to a NVARCHAR(MAX) column. Retrieve it by SELECTing it as you would any other text. We can't give you any idea of the code you'd need as we have no idea even what language you are using, much less the environment it will run under!

XML isn't magic: it's a text-based, human readable format that is "just another string" as far as SQL is concerned.

If that isn't what you mean, we would need a lot more information in order to answer.

Wendelius · Answer 3 · 2021-01-27T05:44:00

Solution 3

If the content of the file is XML, why not store it in an XML field inside the SQL database. Have a look at XML Data Type and Columns (SQL Server) - SQL Server | Microsoft Docs[^]
and Create XML Data Type Variables and Columns - SQL Server | Microsoft Docs[^]

Posted 27-Jan-21 5:44am

Wendelius