Hello, you are not logged in.  Login or sign up
KNOWLEDGE >> Toad Knowledge >> Tips and Tricks
Toad on Twitter Follow Toad Search Toad World Search
Tip Categories
 
Click the folders below to filter the tips by user type, product, or solution area.

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. 
 
Do you have a tip you'd like to share?  Submit your tip.
   BackToCategory   Next  1 of 5
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:
 
   BackToCategory   Next  1 of 5
Copyright 2010 by Quest Software  | Terms Of Use | Privacy Statement | Contact Us