Skip to content

Cleans up queries that you get from SQL Profiler so you can use them better in SQL Studio

Notifications You must be signed in to change notification settings

ruffin--/SqlProfilerQueryCleaner

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

SQL Profiler Query Cleaner

This is a little project I cooked up in less than an hour to save me some time.

SQL Profiler is a great tool to show you exactly what SQL is being executed, along with the parameters. This is especially useful when debugging, because sometimes you aren't sure what SQL is being executed.

However, often times I will find myself having to pull that SQL+parameters out of SQL Profiler and paste it into SQL Server Studio in order to analyze, tweak, debug, etc. SQL Profiler's output looks like:

exec sp_execute sql N'my sql with ''quotes'' escaped string',@MyParam1 datetime, @MyParam2 datetime,@MyParam1='2009-02-11',@MyParam2='2013-03-15'

Which is fine, and *executes* in SQL Studio, but if there's a syntax error, you can't really pinpoint exactly where in the query the error is, and it's harder to manipulate the parameters because you have to do it in two spots, and it's just time-consuming if you're doing this a lot (which I was).

So, fire up this program, paste the SQL Profiler output into the top text box, click the "Clean" button, and the bottom text box will have a more SQL Studio friendly query, like:

DECLARE @MyParam1 datetime='2009-02-11'
DECLARE @MyParam2 datetime='2013-03-15'

MY SQL STRING with 'quotes' that AREN'T ESCAPED

To do:
* This thing uses some really raw string parsing. I would prefer a SQL parser.
* Make this into a SQL Studio extension
* Make a command line/PowerShell version

About

Cleans up queries that you get from SQL Profiler so you can use them better in SQL Studio

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published