Thursday, May 14, 2009

Mapping XML to SQL Tables

I was recently given an file that had over 14,000 lines of XML and was asked to get that XML data into three separate SQL Tables. After a little bit of googling I found this website - which give lots of great examples of how to map an XML file to a sql table.

http://msdn.microsoft.com/en-us/library/aa225754(SQL.80).aspx

One of the features I'd like to highlight is KeepIdentity. This allows you to insert into a table that has Identity Specification set to Yes.

No comments:

Post a Comment