AutoFormat syntax syntax in SSMS 2005 or 2008?
TOAD (for SQL or Oracle) has a simple AUTOFORMAT button that will format your query nicely - I couldn't find this option in SSMS 2005, but a co-worker advised me that it's available in SSMS 2008. I can't find an option there.
This is very useful when inserting a query from another source.
Thanks for any help.
a source to share
SSMS 2008 has a feature called intellisense which is really an autocomplete tool. It only works when connected to a 2008+ server. There is no built-in code formatter / decoder.
You can get this add-on, but: http://www.dpriver.com/products/sqlpp/ssms_index.php . He does just that.
If you don't register it, a dialog box will appear from time to time asking if you want to register, but the functionality remains unlimited forever.
A highly recommended tool!
a source to share
I know this thread is a little old, but you can download the SSMS Tools package ( http://ssmstoolspack.com/ ) which is free for 2008 and 2008 R2.Licensing is required in 2012. I am not using SSMS without installing these tools. It has tons of features, including what you're looking for. It's called "Text Format" and you can use keywords by pressing CNTRL + G whenever you need it. I especially find the SQL history to be fantastic.
a source to share