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
WayneS
SSC Guru
Points: 95460
October 2, 2010 at 3:01 am
#1230671
CREATE PROCEDURE dbo.LoadXMLData (@xmlData XML) AS ...
then use @xmlData.nodes()... to get the data out.
WayneMicrosoft Certified Master: SQL Server 2008Author - SQL Server T-SQL Recipes
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply