Thursday, 8 February 2018

Importing XML into SQL Server Table

The following is an excellent example of how to import XML into a table within SQL Server, and query the XML once imported:

https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/
-
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Updating massive amount of rows whilst avoiding blocking

The following SQL is a good means to split an update on a massive table into smaller chunks, whilst reducing blocking. The method is to upda...