declare @ssss as nvarchar(2000) ;

            set @ssss = N'

            

            

            

            ' ;
            
 
            
declare @idHandle as int ; 

            EXEC sp_xml_preparedocument @idHandle OUTPUT, @ssss
            
insert into  tbl(Name,Intro)

            select * from openxml(@idHandle,N'/root/dbo.tbl')

                with dbo.tbl

            EXEC sp_xml_removedocument @idHandle