T-SQL Tidy

Online T-SQL Statement Parser and Formatter

T-SQL Tidy : Home

T -SQL Tidy takes your messy unformatted T-SQL statements and formats it into nice looking SQL.

 

Enter your SQL in the box below or click Paste.

     Output                                            

 

Casing :

 

 

 

 

 

 

 


Latest News

Tuesday, October 14, 2014 1:50 PM
Windows Technical Preview...
I just can't resist a new version of windows, no matter how how early.Firstly get with the program, http://windows.microsoft.com/en-gb/windows/previewDownload the ISO, create a new virtual machine and bish bash bosh  - minutes later, Windows X(using a VMWare Fusion on my macbook pro)When you log into windows, you go straight to the desktop and well, well, well the start menu is back - and its looking good...It feels like Windows 7.5 (!) ;-)Task View - or multiple desktops is cool, but I do remember a Tweak UI on Windows 95/98 , this has been a feature of XWindows for years!File History - interesting - is this the start of TimeMachine for windows? (Perhaps not) - I will play when I attach a USB drive.Search has been updated, but its not clear how different or new this is.Well thats it for now, it looks good, its quick, I might just switch over as my main OS. ;-)

Wednesday, July 30, 2014 3:14 PM
SSMS Add-in feature request
We all use SSMS, we all love SSMS, it's really good. I know we use it everyday and it hardly ever breaks, but Microsoft don't add new features very often.This can be somewhat frustrating, you can buy 3rd party Add-ins, to extend the functionality, but technically these are unsupported by Microsoft. A while ago, I wrote a couple of SSMS Add-ins for a few missing features that really bugged me, namely; code formatting, scripting data and schema (I know you can do it, but not from a right click on a table) and a versioning Add-in (this tracked each schema change and showed it in SSMS).I stopped working on these a while ago, but after SQLBits, I've decided to dust off the code I uploaded into CodePlex and pick up where I left off.So I put a request for new features on twitter, I got the following requests;1) Cats (I assume the musical)2) Calendar with community events in it3) Porn4) To produce server build documentation5) A quick way of seeing all the extended properties on a table and all its columns. And editing them!6) Some way of indicating the IDENTITY column if there is one?7) Something that shows the partitioning wouldn't go amiss either and the age of the stats8) Size of the table in Kb/Mb? Same with the indexes?9) Is it possible to see number of table reads/scans for a particular table?10) A feature that says "Please remove this software from your computer as you clearly have not idea what you are doing!"? I would prefer something that gives electric shocks as well but I think that Amnesty International and the unions may have object to that!!Feel free to add more features requests to the blog comments.

Sunday, July 27, 2014 3:37 PM
Recharging my SQL Batteries

Friday, May 23, 2014 1:21 AM
Broken Leg...

Thursday, July 11, 2013 1:00 PM
Question: When is a columnstore index not a columnstore index?

Monday, July 08, 2013 5:55 PM
Column Store Index Life Cycle

Monday, July 08, 2013 5:26 PM
Clustered Column store index recap



Usage Stats: (Tidies)

Today: 530

Last 7 days: 5478

Last 30 Days: 20862

This Year: 74326

© T-SQLTidy.com | Valid XHTML | CSS

Download the FREE T-SQL Tidy SQL Server Management Studio Add-in for 2008 and 2008 R2 HERE!