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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment