Hello. In SQL Managment Studio it is possible to execute a query with the output of a plan. The plan is saved to a file with the .sqlplan extension and has xml syntax. I need to parse the plan, but I do not know all the tags (that is, I write the parser based on what I see), so when I open another plan, something might go wrong. Help me please.
- Well, here , for example, there are corresponding XSD-files for different versions of the server (though, for some reason, without 2014). - Yaant
- Thank you, kind man) - iRumba
- @Yaant make a full answer? The answers in the comments are evil. By the way, 2014 is there - current version - PashaPash ♦
- @PashaPash Designed. Initially, I was content with the comment, because I was not sure that the author of the question would have enough XSD schemes. Yes, about the current version did not immediately realize. But there is no 2008 R2. ;) - Yaant
|
1 answer
Here there are corresponding XSD files for different server versions, starting from 2005. The link there is in the documentation, namely in the description of the SET SHOWPLAN_XML command .
Yaant Yaant
3,306 one ten 21
|