tag:blogger.com,1999:blog-257501392534895159.post8380481267505309620..comments2022-10-31T22:06:53.850+08:00Comments on Kenny Hsu's Blog: Convert xml to table in SQL 2005Kennyhttp://www.blogger.com/profile/09636040327211268566noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-257501392534895159.post-28592099079440492992016-04-29T23:39:27.850+08:002016-04-29T23:39:27.850+08:00Great post.Great post.TimHulsehttps://www.blogger.com/profile/16296076036039184775noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-70048448580479300182014-07-09T13:07:24.371+08:002014-07-09T13:07:24.371+08:00Thank you man! You helped a lot!!Thank you man! You helped a lot!!Big Brotherhttps://www.blogger.com/profile/13837385252745723992noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-29634553653968775742012-07-24T18:16:39.173+08:002012-07-24T18:16:39.173+08:00Thanks a lot....:)Thanks a lot....:)Vaishnav Thakurhttp://www.sanshark.comnoreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-63713327561585265952012-07-13T04:48:02.804+08:002012-07-13T04:48:02.804+08:00Very helpful, but what if the column schema for th...Very helpful, but what if the column schema for the table were stored in XML as well? That is, I have 2 sets of XML, one is the column definitions for a table, and the other is the data to insert into the table. Is there an SQL solution for this? or is writing a CLR function the best solution?Marcushttps://www.blogger.com/profile/12859144076323892014noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-50188606847171706762012-06-13T17:35:09.078+08:002012-06-13T17:35:09.078+08:00Thank you Keeny Hsu.....Good Work :)
HariThank you Keeny Hsu.....Good Work :) <br />HariAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-46311057899595864142012-03-12T20:28:39.063+08:002012-03-12T20:28:39.063+08:00Thanks a ton Kenny!Thanks a ton Kenny!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-81714990091538936692012-01-13T23:38:49.211+08:002012-01-13T23:38:49.211+08:00This helped me greatly today.. Thanks very much Ke...This helped me greatly today.. Thanks very much KennyDanielhttps://www.blogger.com/profile/12972461360047746458noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-85622329727473627982011-12-29T09:01:25.636+08:002011-12-29T09:01:25.636+08:00It's a small world. :) How's going?It's a small world. :) How's going?Kennyhttps://www.blogger.com/profile/09636040327211268566noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-88849875830324836362011-12-29T03:34:07.400+08:002011-12-29T03:34:07.400+08:00Yes, we worked at Saltmine.Yes, we worked at Saltmine.sndpvrmhttps://www.blogger.com/profile/07775451652318523969noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-67430334169320654812011-12-14T16:27:08.787+08:002011-12-14T16:27:08.787+08:00Thanks a bunch, really helpful :)Thanks a bunch, really helpful :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-84413791051174370412011-12-02T19:32:56.602+08:002011-12-02T19:32:56.602+08:00Yes. Are you the Sandeep that I familiar with? :)...Yes. Are you the Sandeep that I familiar with? :)Kennyhttps://www.blogger.com/profile/09636040327211268566noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-39995930070794179292011-12-02T13:35:42.100+08:002011-12-02T13:35:42.100+08:00Hey Kenny! Did you worked at Seattle in 2007? Sand...Hey Kenny! Did you worked at Seattle in 2007? Sandeepsndpvrmhttps://www.blogger.com/profile/07775451652318523969noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-25258218577140112942011-08-31T01:01:07.236+08:002011-08-31T01:01:07.236+08:00@Anonymous
Create a stored procedure and take an ...@Anonymous<br /><br />Create a stored procedure and take an input parameter @xml. Feed that parameter with your xml file content.<br /><br />Reference:<br />http://stackoverflow.com/questions/3989395/convert-xml-to-table-sql-serverAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-24746213873211037502011-08-12T02:32:31.731+08:002011-08-12T02:32:31.731+08:00Hi,
I just came across this postings and I'm n...Hi,<br />I just came across this postings and I'm not sure how to use above to solve my problem. I have a fairly large XML file (165MG) which was exported from MS Access and I need in SQL format so I can upload to the server. How do I use above to do this. Any help will greatly be appreciated.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-48549670708992023402010-10-21T23:38:26.054+08:002010-10-21T23:38:26.054+08:00Thank you very much!Thank you very much!Serginhohttps://www.blogger.com/profile/01041249204288212182noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-54671785584686638582010-10-01T02:58:27.031+08:002010-10-01T02:58:27.031+08:00Thanks Kenny, this is exactly what I want.Thanks Kenny, this is exactly what I want.Swatihttp://www.google.comnoreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-14362158877286028642010-05-06T15:08:15.635+08:002010-05-06T15:08:15.635+08:00Thanx kenny,I happened to see ur blog while I was ...Thanx kenny,I happened to see ur blog while I was blogging for some other Info.<br />Great keep up good workAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-58506878220402079822009-05-29T10:54:12.134+08:002009-05-29T10:54:12.134+08:00I spent time on this as well long time ago, and th...I spent time on this as well long time ago, and that's why I put it here so it can save others time on this. I am glad that I can help. :)Kennyhttps://www.blogger.com/profile/09636040327211268566noreply@blogger.comtag:blogger.com,1999:blog-257501392534895159.post-12402385164675210582009-05-29T09:09:21.374+08:002009-05-29T09:09:21.374+08:00Many thanks Kenny - I have been floundering with t...Many thanks Kenny - I have been floundering with this for ages as have obviously many others.<br /><br />Neil DouglasNeil Douglashttps://www.blogger.com/profile/12939480817638964172noreply@blogger.com