Tagged Questions

0
votes
0answers
105 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
571 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 ...