Displaying posts categorized under

XML

Process Element XML and Attribute XML in single node

Process Element XML and Attribute XML in single node.

XML Data in where clause

XML Data in where clause XML Data in Document Types. Step1 : Create Table XMLData. Step2 : Insert XML Document Types Data. Step3 : Where clause for XML Data Type. XML Data in Element Types. Step1 : Truncate XML Data table and insert some element type XML data in the same table. Step2 : Where [...]

SSIS Package to get Table Schema Discrepancy using XML

SSIS Package to get Table Schema Discrepancy using XML. I have created package which uses XML in Execute SQL Task and compares two table’s schema discrepancy. You can use this script to compare table in different instances with different database or in same instance with difference database or in same instance with same database. You [...]