SQL Execution plan to query

Question

0.00/5 (No votes)

See more:

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

Posted 8-Feb-14 11:04am

Adersh Ram

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2014-02-08T14:27:00

Solution 1

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.

Posted 8-Feb-14 14:27pm

Dave Kreskowiak

Updated 8-Feb-14 14:28pm

v2

Comments

Adersh Ram 10-Feb-14 12:45pm

Hi Dave,

Thanks for your response.

Yes i know. I can open the file in a Text editor.....

Actually i am working on a Custom Tool that converts the SQL query with different syntax for another Application. Please look below sample query.

SELECT @SELECT:Employee.ID:ID@,
@SELECT:Employee.LAST_NAME:LAST_NAME@
FROM Employee
WHERE
@WHERE:SECURITY:RESOURCE:Employee.ID@ = 1

The tool convert a SQL query like above syntax. Need to extract the sql query, to know the Columns, table, where conditions for generation above query. I was thinking about the execution plan xml file. I know all the table and conditions and select details available in the execution plans.

Whats your thoughts?

Thanks,
Ram

Dave Kreskowiak 10-Feb-14 13:36pm

You've got me confused. You said you wanted to import the execution plan (which I can only assume is exported from SQL Server Manager). The query string that I see doesn't match the format the you're showing.

Are you taking the query in the execution plan and converting it to this weird format (with the colons all over it)??

Adersh Ram 10-Feb-14 13:47pm

I apologies you for my confusing question.

Yes, my plan is converting the query from the execution plan xml data. I couldn't find any other way to do that.

Is there any other better way to do this conversion?

Thank,
Ram

Dave Kreskowiak 10-Feb-14 14:58pm

Nope. At least I've never heard of anyone or any library to do such a thing.