Import xml schema into SQL Server 2005

Asked By 0 points N/A Posted on -
qa-featured

Hi,

I am using MS SQL Server 2005 for database development. I want to Import xml schema into SQL server 2005. Can anyone tell me the procedure that how can I Import xml schema into SQL server 2005.

SHARE
Best Answer by Rain Bonnie
Answered By 5 points N/A #152267

Import xml schema into SQL Server 2005

qa-featured

My dear,

If you want import XML schemes into the SQL server 2005, you should visit these websites:

They will help you with your XML server.

Thank you.

Answered By 0 points N/A #152269

Import xml schema into SQL Server 2005

qa-featured

Hi,

There are a few other XSD features that SQL Server 2005 doesn’t support. To Import xml schema into SQL server 2005 you have to follow some procedure. The whole procedure is described in the website.

 
Thanks.
Best Answer
Best Answer
Answered By 0 points N/A #152268

Import xml schema into SQL Server 2005

qa-featured

 

You would require to parse the XML as it is into a table like format.

 

You need to remember that XML is just like plain text therefore you need to tell the SQL server what these databases are.

Therefore, no single shot magical bullet exists.

 

INSERT MyTable FROM File = 'bob.xml'

 

Related Questions