Hi,
you can write procedure for this purpose.
create proc dbo.insertdata
(
@inputXml xml
)
AS
BEGIN
select * into #temp
from openxml(@InputXMLHandle,'/Data')
with
(
columnname datatype,
columnname datatype,
columnname datatype,
columnname datatype,
columnname datatype,
)
insert into tablename
select * from #temp
drop #temp
end
hope this will help you....