本文介绍了嗨,我有一个Xml文件数据如何将其转换为Sql中的表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
<?xml version="1.0"?>
-<CalData>
<Serial/>
-<LefCalInfo>
<Uncapped>false</Uncapped>
<NoOfSessionCals>-1</NoOfSessionCals>
<NoOfUsageCals>-1</NoOfUsageCals>
<NoOfNamedCals>20</NoOfNamedCals>
<NoOfClusterNodes>1</NoOfClusterNodes>
<NoOfDocumentCals>80</NoOfDocumentCals>
<NoOfInfrequentNamedCals>0</NoOfInfrequentNamedCals>
<NoOfConcurrentInfrequentNamedCals>0</NoOfConcurrentInfrequentNamedCals>
</LefCalInfo>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\AJAY</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E489C87F258BF2</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\ASHISH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4958393E93E94</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\ASHOK</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E49849EDB363BF</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE1</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4990E1CD2DE3F</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE2</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E499091585E0E7</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE3</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4990C69876543</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\CHANDRA</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4916E67104EE3</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\INDRANI</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E49849F240795D</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\JIGISHA.S</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E493CE6F98D76B</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\KPKADMIN</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498B61BE02469</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\MAHESH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4620C258BF259</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\PIYUSH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498CB1B97530F</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\PRASHANT.G</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4944647042BFE</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\RAHUL</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E489695CD2DE3F</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\RAJ</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E493315EA00C23</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\SEETHALAKSHMI.H</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4976FF839A5BC</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\SHYJU.R</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E49527F6FE1A8C</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\VIMAL.T</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E499085F92C5F9</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\VISHY.C</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4916E3D0F8CB4</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
-<PerServerCalData>
-<PerServerCalData>
<ServerName>COLOSERV1</ServerName>
<LastUpdated>40E4990EC1E573AC</LastUpdated>
</PerServerCalData>
</PerServerCalData>
<AvailableUsageCals>BFF0000000000000</AvailableUsageCals>
<UsageCalUpdateTimestamp>0000000000000000</UsageCalUpdateTimestamp>
-<PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\ACT\ACT.QVW</DocumentName>
<NoOfNamedCals>5</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE1</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E487AD6468ACF1</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\ACT\ACT_TALLY.QVW</DocumentName>
<NoOfNamedCals>2</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\INDRANI</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E478F0E2833945</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\FMG\FMG.QVW</DocumentName>
<NoOfNamedCals>6</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\CHASE.H</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E486E9E2FC9630</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\GEOFF.W</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E486E9ECF1357A</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\SANDEEP.K</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E46E32612F684C</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\SEBASTIAN.M</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E48B2F76E5D4C4</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\VAIBHAV.O</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4988B36543210</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\FMG\FMG_AUTOMATION.QVW</DocumentName>
<NoOfNamedCals>1</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\VAIBHAV.O</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E48110AC5F92C6</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\FUND_MIS\IVFA_FUND.QVW</DocumentName>
<NoOfNamedCals>3</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\AMITH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>FE37E43C8800759C</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\DHARMESH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>FE37E43C8800759C</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\SUTHESH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>FE37E43C8800759C</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>false</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\FUND_MIS\MIS\IVFA_MIS.QVW</DocumentName>
<NoOfNamedCals>1</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\DHARMESH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>FE37E43C8800759C</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>false</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\HICARE\HICARE.QVW</DocumentName>
<NoOfNamedCals>10</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE3</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4978BA32D21C1</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\NAITIK</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E49890A93E93E9</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\RAHUL.P</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498923F3DD1BB</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\IFAPL\IFAPL_WIP.QVW</DocumentName>
<NoOfNamedCals>5</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE3</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E497889CEB2408</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\FINCARE1</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4988D38091A2B</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\FINCARE3</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4958CD6480F2C</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\SUTHESH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4990B966054F4</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\INLOGISTICS\IN_LOGISTICS.QVW</DocumentName>
<NoOfNamedCals>3</NoOfNamedCals>
<NamedCalsAllocated/>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\INLOGISTICS\IN_LOG_OP_DASHBOARD.QVW</DocumentName>
<NoOfNamedCals>3</NoOfNamedCals>
<NamedCalsAllocated/>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\INTERNAL\FUND\IVFA_FUND.QVW</DocumentName>
<NoOfNamedCals>1</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\SUTHESH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>FE37E43C8800759C</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>false</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\INTERNAL\MIS\IVFA_MIS.QVW</DocumentName>
<NoOfNamedCals>1</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\DHARMESH</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>FE37E43C8800759C</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>false</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\KEYA\KEYA SALES ANALYSIS.QVW</DocumentName>
<NoOfNamedCals>16</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\ABHIJIT.B</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4990D8C3B2A19</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\AYSHA.AG</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4982CD1111111</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\KIRAN.P</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498B0121C10B0</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\MUTHU.K</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498F068ACF136</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\RAHUL.SAINI</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498CD91BAF98E</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\RAJU.D</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E49908D950C840</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\RATAN.P</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498D1BDD1BAFA</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\ROOPESH.H</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498CCC2BFE7BA</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\SANJEEV.N</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498B1B89ABCDF</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\SHAILENDRA.S</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498CE4A6DFC35</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\KEYA\KEYA WIP.QVW</DocumentName>
<NoOfNamedCals>2</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\AYSHA.AG</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4982BAADB363C</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE1</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E487AD55FF3DD2</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\MERU\MERU MIS AS IS.QVW</DocumentName>
<NoOfNamedCals>2</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\VIMAL.T</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E48F73A1C10B00</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\MERU\MERU MIS THRU AUTOMATION.QVW</DocumentName>
<NoOfNamedCals>2</NoOfNamedCals>
<NamedCalsAllocated/>
<AllowDynamicAllocation>false</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\MERU\MERU WIP.QVW</DocumentName>
<NoOfNamedCals>2</NoOfNamedCals>
<NamedCalsAllocated/>
<AllowDynamicAllocation>false</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\RDC\RDC.QVW</DocumentName>
<NoOfNamedCals>3</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE3</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E487A9871C71C7</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\UMESH.G</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E49791E5A43821</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>MANISH.M</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>FE37E43C8800759C</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\ROBO\ROBO.QVW</DocumentName>
<NoOfNamedCals>4</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE1</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E48A47EAAAAAAB</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\CFOBRIDGE3</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4878DB60B60B6</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\MURTHY.V</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E496E5C3518A6E</LastUsed>
</CalAllocEntry>
-<CalAllocEntry>
<Name>COLOSERV1\SONICA.G</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4952C6D21C10B</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\ROBO\ROBO_SALES_REPORT.QVW</DocumentName>
<NoOfNamedCals>2</NoOfNamedCals>
<NamedCalsAllocated/>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\ROBO\ROBO_SALES_REPORT\ROBO_SALES_ANALYSIS.QVW</DocumentName>
<NoOfNamedCals>2</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\SONICA.G</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E498505B66C77E</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\UEM\UEM_APPLICATION.QVW</DocumentName>
<NoOfNamedCals>1</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\RAJEEV.M</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>40E4878D2E450672</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
-<PerDocumentCalData>
<DocumentName>IVFA\VKL\VKL_WIP.QVW</DocumentName>
<NoOfNamedCals>2</NoOfNamedCals>
-<NamedCalsAllocated>
-<CalAllocEntry>
<Name>COLOSERV1\KRANTHI.B</Name>
<ToBeDeleted>FE37E43C8800759C</ToBeDeleted>
<LastUsed>FE37E43C8800759C</LastUsed>
</CalAllocEntry>
</NamedCalsAllocated>
<AllowDynamicAllocation>true</AllowDynamicAllocation>
<NoOfEmbeddedNamedCals>0</NoOfEmbeddedNamedCals>
<EmbeddedSerial/>
<NamedCalsInUse/>
</PerDocumentCalData>
</PerDocumentCalData>
<NamedCalsInUse/>
<SessionCalsInUse/>
<InfrequentNamedCalsInUse/>
<InfrequentSessionCalsInUse/>
<InfrequentNamedCalsAllocated/>
<SessionsOnUsageCals>0</SessionsOnUsageCals>
</CalData>
推荐答案
DECLARE @xmldoc xml
SET @xmldoc = '
<caldata>
<serial />
<lefcalinfo>
<uncapped>false</uncapped>
<noofsessioncals>-1</noofsessioncals>
<noofusagecals>-1</noofusagecals>
<noofnamedcals>20</noofnamedcals>
<noofclusternodes>1</noofclusternodes>
<noofdocumentcals>80</noofdocumentcals>
<noofinfrequentnamedcals>0</noofinfrequentnamedcals>
<noofconcurrentinfrequentnamedcals>0</noofconcurrentinfrequentnamedcals>
</lefcalinfo>
<namedcalsallocated>
<calallocentry>
<name>COLOSERV1\AJAY</name>
<tobedeleted>FE37E43C8800759C</tobedeleted>
<lastused>40E489C87F258BF2</lastused>
</calallocentry>
<calallocentry>
<name>COLOSERV1\ASHISH</name>
<tobedeleted>FE37E43C8800759C</tobedeleted>
<lastused>40E4958393E93E94</lastused>
</calallocentry>
<calallocentry>
<name>COLOSERV1\ASHOK</name>
<tobedeleted>FE37E43C8800759C</tobedeleted>
<lastused>40E49849EDB363BF</lastused>
</calallocentry>
</namedcalsallocated>
</caldata>'
SELECT a.col1.value('(Name)[1]', 'nvarchar(100)') AS Name,
a.col1.value('(ToBeDeleted)[1]', 'nvarchar(100)') AS ToBeDeleted,
a.col1.value('(LastUsed)[1]', 'nvarchar(100)') AS LastUsed
INTO #SomeTable
FROM @xmldoc.nodes('/CalData/NamedCalsAllocated/CalAllocEntry') a(col1)
SELECT * FROM #SomeTable
The result would be
The result would be
Name ToBeDeleted LastUsed
-------------- ---------------- -----------------
COLOSERV1\AJAY FE37E43C8800759C 40E489C87F258BF2
COLOSERV1\ASHISH FE37E43C8800759C 40E4958393E93E94
COLOSERV1\ASHOK FE37E43C8800759C 40E49849EDB363BF
这篇关于嗨,我有一个Xml文件数据如何将其转换为Sql中的表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!