Query Plan read using T-SQL
If plan from a saved file
XML-JSON
Escape XML special characters in SQL Server Query
Here I am trying to how to work with special character in a SQL Server. Result of query (include type keyword) Result of query (without type keyword) Result of above 3 query Other Refrence
Xml with null Column
How to get null value from XML column. XML requirements XML tags are case sensitive. Opening and closing tags must be written with the same caseIn XML, all elements must be properly nested within each otherIn XML, the attribute values must always be quoted“xsi:nil” represents the null value in XML Other Reference:
How to read the SQL Server query plan file using TSQL
Here I am trying to read sql server plan (Execution query Plan) file from ssms query.
How to work with xml type using Query
OPENXML, a Transact-SQL keyword, provides a rowset over in-memory XML documents that is similar to a table or a view. sp_xml_preparedocument. This parses the XML document and returns a handle to the parsed document that is ready for consumption. Example: Using nodes() Example: Using OpenXml() on the xml Data Type Using Cross Apply References: https://docs.microsoft.com/en-us/sql/relational-databases/xml/openxml-sql-server?view=sql-server-ver15
Tables contains XML columns
Return table name with schema which contains xml columns in databases
