0
votes
0answers
216 views

How to create table set from several XSD in SQL Server 2012 or with VS 2012

Is there any solution in T-SQL or in C# how to create XML schema collection in T-SQL or C#? Problem is I cannot use: USE Database_test GO CREATE XML SCHEMA COLLECTION Collection_from_XSD AS N' ...
13
votes
2answers
663 views

Optimising plans with XML readers

Executing the query from here to pull the deadlock events out of the default extended events session SELECT CAST ( REPLACE ( REPLACE ( XEventData.XEvent.value ...