Minimize
Tip Categories
Click the folders below to filter the tips by user type, product, or solution area.

 
WELCOME, GUEST
 
 

Toad® Tips and Tricks
User Submitted Insights

Toad Tips and Tricks are a collection of suggestions, insights and how-tos from our in-house experts as well as Toad users from around the world.  

 FEATURED DOWNLOADs:   
Complete Toad for Oracle Tips and Trick Presentation (Toad 10.0) 
by Toad expert, Jeff Smith.
 
  Complete Toad for Oracle Tips and Trick Presentation (Toad 10.5) 
by Toad expert, Jeff Smith.
 

Do you have a tip you'd like to share?  Submit your tip.
Previous   BackToCategory   Next  2 of 6
Format your T-SQL code

Toad for SQL Server makes it easy to format your T-SQL code .

Format your T-SQL Code the Way You Like It

Toad for SQL Server includes a comprehensive parser and formatter that allows you to easily create visually appealing Transact-SQL code that adheres to company standards:
  • Select from one of our pre-defined SQL formatting templates, which include both long and short format options as well as options for those who prefer leading vs. trailing commas
  • Customize an existing pre-defined template or create a new template of your own
  • Easily switch between templates and format your code
It’s easy to get started formatting your T-SQL code:
  1. Select a template:

     
  2. Click the format button on the toolbar or select the Editor context-menu Format SQL option and your T-SQL code is automatically formatted:

     
  3. To customize, create, and manage templates, go to the Options – Editor – Formatter:
     
     
  4. Use the Preview option to see how your code will appear with the template:
 
Previous   BackToCategory   Next  2 of 6