要执行的SQL执行计划 [英] SQL Execution plan to query

问题描述

Hello Experts，



我有一个sql查询执行计划xml文件，我可以使用.Net将执行计划xml转换为T-Sql查询吗？ />


有没有帮助班？



请分享你的想法。



谢谢，

Ram

Hello Experts,

I have a sql query execution plan xml file, can i convert a execution plan xml to T-Sql query using .Net ?

Is there any helper classes ?

Please share your thoughts.

Thanks,
Ram

推荐答案

您是否打算在记事本中打开.XML文件并查看周围??



没有将执行计划转换回查询语句。但是，您可以只在XmlDocument中打开文件，然后只获取原始查询语句。它以明文形式存在。



.NET Framework中没有帮助程序类可以为您执行此操作。您必须编写XML代码才能执行此操作。

Did you bother to open the .XML file in Notepad and take a look around??

There is no "converting" the execution plan back to a query statement. You can however, just open the file up in an XmlDocument and just grab the original query statement. It's in there in clear text.

There is no helper class in the .NET Framework to do this for you. You have to write the XML code to do it.

这篇关于要执行的SQL执行计划的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！