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