I have found this one. http://support.microsoft.com/default.aspx/kb/316005. Is it good enough?
The XML is generated by another system on daily basis. So, the import should be able to handle insert and update cases. How can I do that? Thanks!
XML Bulk load deals with loading up the data initially into SQL server. To update/delete, try this http://msdn2.microsoft.com/en-us/library/aa258671(SQL.80).aspx.
Note that SQL2005 supports xml data type natively, meaning that you can store the whole xml doc in a sql table column w/o breaking it up and saving it as a table. Keep in mind that you have that option as well depending on your specific use scenarios.
|||I have read something about the updategram. However, the information is quite piece by piece. Is there any example showing how it's working in real situation?
No comments:
Post a Comment