PX排列组合新04.22结构学习

示例1：从XML中解析数据到表变量

DECLARE @ItemMessage XML DECLARE @ItemTable TABLE(ItemNumber INT PRIMARY KEY,ItemDescription NVARCHAR(300)) SET @ItemMessage=N'<ItemList> <Item>     <ItemNumber>1</ItemNumber>     <ItemDescription>XBox 360,超值</ItemDescription> </Item> <Item>     <ItemNumber>2</ItemNumber>     <ItemDescription>Windows Phone7,快来尝鲜吧</ItemDescription> </Item> </ItemList>' INSERT INTO @ItemTable ( ItemNumber, ItemDescription ) SELECT T.c.value('(ItemNumber/text())[1]','INT'), T.c.value('(ItemDescription/text())[1]','NVARCHAR(300)') FROM @ItemMessage.nodes('/ItemList/Item') AS T(c) SELECT ItemNumber, ItemDescription FROM @ItemTable

 

begin#F26B08F5D2A212A51B373EAEEEFD9EA1973A6BEF0F98223B023EBB5A02EF4AC0C2281A0552D6FB60F6FD5428D5E277C73F341BFABB85C9DB3E8ABEDE232B55E7187A5D10B9C23D8FBD42C58A73B88A0EE89BCDF7AA41604EEEE76287574BAF7F3A22201E5A3A0AB7917913056F2557F33E5B971040E87DE8AE6053A7D4FC91B84FC41CD8216D184CC223D506A4CE1D0C5AC480B2380BE3E2E0AAA90AC601520D019153195BE5794FCCB2AC39F471662663237BCB311ECB7A407CB2EF2D2901BCAC2A1D0FD84C44FEDD14E262574D45E434D312EFB33C43180BE090FECE930521672191B9C763DAB2E9A118772A61F91453A3835F29956A431F013945095DD477CEA333C856E32154CFCE39B0CE48B31F49FE7903E656ECB37EBF2180265D7E815B0938C56A9D392D0F57D1B6B17F27B90C3ECF1C727D2385839FC3791E3507B2CC743CDFAD1F2F3C22A5D55E78B72786C13219C01453CF45AA9B947A34A7431E1C1A0671C8108199FDA0C05E6C0F7B3A51BC79D40CA3997418040AF424DF39142B1BEA07F0411CB6ABFB0CE37F37A8E43DF2A8D7C5614B5E7DF3D08603BD1C73AD765DDF18CB008B4A8713A79E784A5515E3E1B36D8E06FA509342B1DA88EB2F1E07B239A5D280E32716FEAA31ED441FD01CCF8F2D6AA68617059F12C676900366B11BF20DBF1D70FEF54B8E45DBB26485CCC87394AF555656565696166FCD0DAB1A98A3D9B4807052D88C6C89E75B594BACC4C9832D1C22222222222222222222222222222292126F8AD7138A81E2FA4863D2A030B44EEFECA311F205943BB85DCEC9B922FC24E3E0D5AA622AA9C7649F5B05033708A52358D04206C679DE8C32E7858B46F9A9AFDEBD1A745032BDF8F45F503339BCD3D4D4D4D4D4B557B8EC1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A1A57CCB58A3C9B2A2928F27E9939B4971D6B0BD8373516F8D32154DB4A32EB1702C9A91FEE15BA1F41DA87164CFB81D3850412A4FE71418C4CED9F48EF1ACF1C3828B2769EB5C389EA7B17026464DB40A175BCA3538252C1BCABFDA733541E1188371084848484848484848484848484847DFF58B1F047A43D78725A4C188B7316AC0C10F3C93499D167F1D40D9579C5562529037BB35323AA549E58AECAF59DCF41DD9897FF8832ED3998E06FCA39DF7A44B56AA32C0F8B1CC7279973A1E8183CE33FAD3402E61E156B4EAE7E003D86385266314422AF0E5625D9B613CD85C236AB925B88803A39EF774A8BB19E602CEA7C5914E39BE5B4AACEC88D532D4CA713815B43EBA39F7CC433E05AA3DD6A10C62C1DEF868240462F66D585818869ABCCC8!end

运行结果： ItemNumber ItemDescription 1 XBos 360超值 2 Windows Phone7 快来尝鲜吧