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 |
JanakiRam
Starting Member
22 Posts |
Posted - 2013-06-28 : 06:47:05
|
Need a query for xml data insert to table columns are dynamically addedJanakiRam |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
JanakiRam
Starting Member
22 Posts |
Posted - 2013-06-28 : 07:42:20
|
BCP OR OPENROWSET BULK ...........JanakiRam |
|
|
JanakiRam
Starting Member
22 Posts |
Posted - 2013-06-28 : 07:44:38
|
I Have number of XML files so i could not specify any column names, based on xml file columns new table will be generated or insert into any hash table, Please...........JanakiRam |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-28 : 10:55:18
|
hash table? why a hash table? do you realize hash table has scope only within the connection in which its created?A for looping through XML files you need to use a loop in T-SQL or SSIS------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|