Insert statement syntax for data using xml file

Question

Post reply

Insert statement syntax for data using xml file

namrata.dhanawade-1143388

Ten Centuries

Points: 1269
More actions
October 1, 2010 at 11:25 pm

#228937

Hi,
I remember using an xml file containing huge amount of data (bulk/multiple rows) used as an input parameter to a SP to insert into the table using a single insert statement. I dont remember the syntax somehow.
Can anybody help?
Thanks,
Namrata

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

CREATE PROCEDURE dbo.LoadXMLData (@xmlData XML) AS ...

then use @xmlData.nodes()... to get the data out.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2