Import XML file to database (MS Server 2000) using procedure (transact sql) ???

[Szaki]

I must import some exemplary file to database (MS Srrver 2000) ofcourse
using procedure Transact SQL.
This file must:
1.Read the xml file
2. Create table
3. Import this date from xml file to my database

Ps. I create procedure who File xml imports to base, but unfortunately she
only schedule when earlier create a table or table is created.So I need (I
think) create such mini parser in language transact SQL.
Does someone have some ideas?

For every help Thanks

==== example file xml =============== =============== =============
<root>
<Cust>
<IDosoby>1</IDosoby>
<Imie>Lukasz</Imie>
<Nazwisko>Przyp adek</Nazwisko>
</Cust>
<Cust>
<IDosoby>2</IDosoby>
<Imie>Dariusz </Imie>
<Nazwisko>Mro z</Nazwisko>
</Cust>
<Cust>
<IDosoby>3</IDosoby>
<Imie>Tomasz</Imie>
<Nazwisko>Kol o</Nazwisko>
</Cust>
</root>
=============== =============== =============== ==============
--
Luk

[Vinod Kumar]

Not sure of the exact requirement. But if you can parse the XML and then
using OPENXML shred it into a new table.

SELECT * INTO <MyNewTable>
FROM OPENXML (@idoc, '/root/')

Where @idoc is the document handle of the internal representation of an XML
document.

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

"Szaki" <lj**@gazeta.pl > wrote in message
news:cm******** **@inews.gazeta .pl...

I must import some exemplary file to database (MS Srrver 2000) ofcourse
using procedure Transact SQL.
This file must:
1.Read the xml file
2. Create table
3. Import this date from xml file to my database

Ps. I create procedure who File xml imports to base, but unfortunately she
only schedule when earlier create a table or table is created.So I need (I think) create such mini parser in language transact SQL.
Does someone have some ideas?

For every help Thanks

==== example file xml =============== =============== =============
<root>
<Cust>
<IDosoby>1</IDosoby>
<Imie>Lukasz</Imie>
<Nazwisko>Przyp adek</Nazwisko>
</Cust>
<Cust>
<IDosoby>2</IDosoby>
<Imie>Dariusz </Imie>
<Nazwisko>Mro z</Nazwisko>
</Cust>
<Cust>
<IDosoby>3</IDosoby>
<Imie>Tomasz</Imie>
<Nazwisko>Kol o</Nazwisko>
</Cust>
</root>
=============== =============== =============== ==============
--
Luk

[Uri Dimant]

Hi
May be it is not exactly what you wanted but I ma sure you will get an idea.

declare @list varchar(8000)
declare @hdoc int
set @list='<Northwi nd..Orders OrderId="10643"
CustomerId="ALF KI"/><Northwind..Or ders OrderId="10692" CustomerId="ALF KI"/>'
select @list='<Root>'+ char(10)+@list
select @List = @List + char(10)+'</Root>'
exec sp_xml_prepared ocument @hdoc output, @List

select OrderId,Custome rId
from openxml (@hdoc, '/Root/Northwind..Orde rs', 1)
with (OrderId int,
CustomerId varchar(10)
)
exec sp_xml_removedo cument @hdoc

"Szaki" <lj**@gazeta.pl > wrote in message
news:cm******** **@inews.gazeta .pl...

I must import some exemplary file to database (MS Srrver 2000) ofcourse
using procedure Transact SQL.
This file must:
1.Read the xml file
2. Create table
3. Import this date from xml file to my database

Ps. I create procedure who File xml imports to base, but unfortunately she
only schedule when earlier create a table or table is created.So I need (I think) create such mini parser in language transact SQL.
Does someone have some ideas?

For every help Thanks

==== example file xml =============== =============== =============
<root>
<Cust>
<IDosoby>1</IDosoby>
<Imie>Lukasz</Imie>
<Nazwisko>Przyp adek</Nazwisko>
</Cust>
<Cust>
<IDosoby>2</IDosoby>
<Imie>Dariusz </Imie>
<Nazwisko>Mro z</Nazwisko>
</Cust>
<Cust>
<IDosoby>3</IDosoby>
<Imie>Tomasz</Imie>
<Nazwisko>Kol o</Nazwisko>
</Cust>
</root>
=============== =============== =============== ==============
--
Luk

[Szaki]

Thanks,
Could you correct my procedure that she acted correctly, becouse I'm a
beginning programist.
thanks for any help
U¿ytkownik "Vinod Kumar" <vinodk_sct@NO_ SPAM_hotmail.co m> napisa³ w
wiadomo¶ci news:cm******** **@news01.intel .com...

Not sure of the exact requirement. But if you can parse the XML and then
using OPENXML shred it into a new table.

SELECT * INTO <MyNewTable>
FROM OPENXML (@idoc, '/root/')

Where @idoc is the document handle of the internal representation of an XML document.

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

"Szaki" <lj**@gazeta.pl > wrote in message
news:cm******** **@inews.gazeta .pl...

I must import some exemplary file to database (MS Srrver 2000) ofcourse
using procedure Transact SQL.
This file must:
1.Read the xml file
2. Create table
3. Import this date from xml file to my database

Ps. I create procedure who File xml imports to base, but unfortunately she only schedule when earlier create a table or table is created.So I need

(I

think) create such mini parser in language transact SQL.
Does someone have some ideas?

For every help Thanks

==== example file xml =============== =============== =============
<root>
<Cust>
<IDosoby>1</IDosoby>
<Imie>Lukasz</Imie>
<Nazwisko>Przyp adek</Nazwisko>
</Cust>
<Cust>
<IDosoby>2</IDosoby>
<Imie>Dariusz </Imie>
<Nazwisko>Mro z</Nazwisko>
</Cust>
<Cust>
<IDosoby>3</IDosoby>
<Imie>Tomasz</Imie>
<Nazwisko>Kol o</Nazwisko>
</Cust>
</root>
=============== =============== =============== ==============
--
Luk