SQLServer中在存储过程中操作XML格式数据作

CREATE   PROCEDURE   RST_InsertRingData
(  
      @xml   XML  
)  
AS  
BEGIN  
            DECLARE   @Pointer   INT  
            EXECUTE   sp_xml_preparedocument   @Pointer   OUTPUT,@xml  

            INSERT   INTO   RingData
            (
                        CI_IdCard,  
                        machineID,  
                        LHTimeOfFLTR,
                        LHHitTimesFLTR,
                        LHTimeOfFRTL,
                       LHHitTimesFRTL,
                        RHTimeOfFLTR,
                          RHHitTimesFLTR,
                         RHTimeOfFRTL,
                        RHHitTimesFRTL,
                            AddTime,
                            IsDel,
                            Description
                          
            )
            SELECT  
                        CI_IdCard,  
                        machineID,  
                        LHTimeOfFLTR,
                        LHHitTimesFLTR,
                        LHTimeOfFRTL,
                       LHHitTimesFRTL,
                        RHTimeOfFLTR,
                          RHHitTimesFLTR,
                         RHTimeOfFRTL,
                        RHHitTimesFRTL,
                            AddTime,
                            IsDel,
                            Description
                          
            FROM  
            OPENXML   (@Pointer, '/TestResult/Purchase ')  
            WITH  
            (  
                        CI_IdCard nvarchar(100),  
                        machineID nvarchar(50),  
                        LHTimeOfFLTR int,
                        LHHitTimesFLTR int,
                        LHTimeOfFRTL int,
                       LHHitTimesFRTL int,
                        RHTimeOfFLTR int,
                          RHHitTimesFLTR int,
                         RHTimeOfFRTL int,
                        RHHitTimesFRTL int,
                            AddTime datetime,
                            IsDel int,
                            Description nvarchar(100)
                        
            )  

            EXEC   sp_xml_removedocument   @Pointer  
END    



exec RST_InsertRingData ' <TestResult>  

<Purchase  CI_IdCard="123456"    machineID="123456" LHTimeOfFLTR="2"  LHHitTimesFLTR="2"    LHTimeOfFRTL="2"    LHHitTimesFRTL="2"  RHTimeOfFLTR="2"  RHHitTimesFLTR="2"   RHTimeOfFRTL="2"    RHHitTimesFRTL="2"    AddTime="2013/11/2"  IsDel="1"     Description ="Welcom To Beijing" />  
<Purchase  CI_IdCard="123456"    machineID="123456" LHTimeOfFLTR="2"  LHHitTimesFLTR="2"    LHTimeOfFRTL="2"    LHHitTimesFRTL="2"  RHTimeOfFLTR="2"  RHHitTimesFLTR="2"   RHTimeOfFRTL="2"    RHHitTimesFRTL="2"    AddTime="2013/11/2"  IsDel="1"     Description ="Welcom To Beijing" />  
<Purchase  CI_IdCard="123456"    machineID="123456" LHTimeOfFLTR="2"  LHHitTimesFLTR="2"    LHTimeOfFRTL="2"    LHHitTimesFRTL="2"  RHTimeOfFLTR="2"  RHHitTimesFLTR="2"   RHTimeOfFRTL="2"    RHHitTimesFRTL="2"    AddTime="2013/11/2"  IsDel="1"     Description ="Welcom To Beijing" />  

</TestResult> '

select * from RingData
CREATE TABLE [dbo].[RingData](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [CI_IdCard] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
    [machineID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
    [LHTimeOfFLTR] [int] NULL,
    [LHHitTimesFLTR] [int] NULL,
    [LHTimeOfFRTL] [int] NULL,
    [LHHitTimesFRTL] [int] NULL,
    [RHTimeOfFLTR] [int] NULL,
    [RHHitTimesFLTR] [int] NULL,
    [RHTimeOfFRTL] [int] NULL,
    [RHHitTimesFRTL] [int] NULL,
    [AddTime] [datetime] NULL,
    [IsDel] [int] NULL,
    [Description] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
)