SQL Server通过XML批量操作

SET @DetailID=@@IDENTITY

DECLARE @hdoc INT
   Exec sp_xml_preparedocument @hdoc OUTPUT,@AgendasXML
   SELECT  *  INTO #item FROM OPENXML( @hdoc,'items/item')
   WITH ( name NVARCHAR(30)   '@name',
     [page] NVARCHAR(50) '@email'
     )
   DECLARE @name NVARCHAR(30),@page INT
   DECLARE  Table_Data   CURSOR  For  select [name],[page] from #item
   OPEN Table_Data
   FETCH NEXT FROM  Table_Data INTO  @name,@page
   WHILE  @@FETCH_STATUS = 0
   BEGIN
    INSERT INTO [dbo].[tabel]([ID],[name],[page],[Status],[CreateTime])
     VALUES(@DetailID,@name,@page,1,GETDATE())
    FETCH NEXT FROM  Table_Data INTO  @name,@page
   END
   CLOSE Table_Data
   DEALLOCATE Table_Data