Load XML file in the sql server 2005 table......
-
Hi, I want to load xml file i to the sql server 2005 table. Foe e.x i have a xml file containing details '<'employee'>' '<'firstname'>'abc'<'/firstname'>' '<'lastname'>'xyz'<'/lastname'>' '<'/employee'>' now i want to load this data into the table in sql server 2005 database. The table contains 2 columns: firstname and lastname i want to load this xml data to this table in to the corresponding column. so is it possible through T-sql query.ID yes,please let me know and if not please give me some alternative to load this xml data in to the table. Regards, pranav.
Pranav Dave
-
Hi, I want to load xml file i to the sql server 2005 table. Foe e.x i have a xml file containing details '<'employee'>' '<'firstname'>'abc'<'/firstname'>' '<'lastname'>'xyz'<'/lastname'>' '<'/employee'>' now i want to load this data into the table in sql server 2005 database. The table contains 2 columns: firstname and lastname i want to load this xml data to this table in to the corresponding column. so is it possible through T-sql query.ID yes,please let me know and if not please give me some alternative to load this xml data in to the table. Regards, pranav.
Pranav Dave
Looks like plenty of samples here[^]
Never underestimate the power of human stupidity RAH
-
Hi, I want to load xml file i to the sql server 2005 table. Foe e.x i have a xml file containing details '<'employee'>' '<'firstname'>'abc'<'/firstname'>' '<'lastname'>'xyz'<'/lastname'>' '<'/employee'>' now i want to load this data into the table in sql server 2005 database. The table contains 2 columns: firstname and lastname i want to load this xml data to this table in to the corresponding column. so is it possible through T-sql query.ID yes,please let me know and if not please give me some alternative to load this xml data in to the table. Regards, pranav.
Pranav Dave
hi see this http://www.codeproject.com/script/Forums/View.aspx?fid=1725&msg=2932578[^] Hope it Helps
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za