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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Reading xml file

Author  Topic 

gurusamy.senthil
Yak Posting Veteran

65 Posts

Posted - 2007-01-24 : 04:14:24
Hello Everyone,

Is it possible to read the values from the xml file and insert into the sql table. Please advice...

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-24 : 04:18:25
There are few thread about XML in the FAQ http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210

Take a look at it.


KH

Go to Top of Page

gurusamy.senthil
Yak Posting Veteran

65 Posts

Posted - 2007-01-24 : 04:39:27
I am confused after seeing that. My scenario is I have to read the xml file from local path and Insert the values to table.

I was thinking to do that using Stored procedures. Tell me now can I locate the directory and file name inside the sp, and also tell me how to read the values from the xml file and insert into the the tbale.
Go to Top of Page
   

- Advertisement -