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.
| Author |
Topic |
|
chazman113
Starting Member
1 Post |
 Posted - 2008-07-03 : 10:37:31
|
| Heres the deal, I have an XML file thats about 70 megs. I'm generally a coldfusion programmer and it of course can't handle something that big. I would like to do it natively in a stored procedure. I'm a complete noob when it comes to T-SQL programming, could someone throw me in the right direction as to how to get the following done: * Create a stored procedure (Server is SQL Server 2005) - think I can handle this one * Read in the XML file (on the local hard drive) * Parse it into something I can loop over * Run a bunch of insert statements based on this loop * Set it up to run on a schedule every day * Not break my serverThanks in advance! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-03 : 10:47:56
|
| you will have to see OPENXML in Books online.http://technet.microsoft.com/en-us/library/ms345115.aspx |
 |
|
|
|
|
|
Best way to solve a large XML import quandary