bulk insert

--0. ######## DB에임시테이블생성########
CREATE TABLE [dbo].[tbl_Test](
       [seq] [varchar](50) COLLATE Korean_Wansung_CI_AS NULL,
       [oldnm] [varchar](50) COLLATE Korean_Wansung_CI_AS NULL,
       [newnm] [varchar](50) COLLATE Korean_Wansung_CI_AS NULL
) ON [PRIMARY]

--1. ######## DB에SP생성##################
Create PROC usp_XML_Test
    @RegistXML xml
AS
begin
INSERT INTO [Temp].[dbo].[tbl_Test]
           ([seq]
           ,[oldnm]
           ,[newnm])
SELECT
 M.Item.query('./SEQ').value('.','VARCHAR(50)') SEQ,
  M.Item.query('./OLDNM').value('.','VARCHAR(50)') [OLDNM],
  M.Item.query('./NEWNM').value('.','VARCHAR(50)') [NEWNM]
FROM @RegistXML.nodes('/ROOT/INFO') AS M(ITEM)
end
--2. ######## 외부 웹서버로부터외부 xml정보받아와서SP호출##################
exec usp_XML_Test
'<ROOT xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
   <INFO>
     <SEQ>1</SEQ>
     <OLDNM>a군</OLDNM>
     <NEWNM>x군</NEWNM>
   </INFO>
   <INFO>
     <SEQ>2</SEQ>
     <OLDNM>b군</OLDNM>
     <NEWNM>b군</NEWNM>
   </INFO>
   <INFO>
     <SEQ>3</SEQ>
     <OLDNM>c군</OLDNM>
     <NEWNM></NEWNM>
   </INFO>
</ROOT>''<ROOT xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
   <INFO>
     <SEQ>1</SEQ>
     <OLDNM>a군</OLDNM>
     <NEWNM>x군</NEWNM>
   </INFO>
   <INFO>
     <SEQ>2</SEQ>
     <OLDNM>b군</OLDNM>
     <NEWNM>b군</NEWNM>
   </INFO>
   <INFO>
     <SEQ>3</SEQ>
     <OLDNM>c군</OLDNM>
     <NEWNM></NEWNM>
   </INFO>
</ROOT>'
--3. ######## 결과확인##################
select * from dbo.tbl_Test