SQL Server Management Studio ( SSMS ) – Editor – Tabs and Spaces

Background

When writing code, one gets to decide whether Tabs are kept as is; or have the editor automatically converts tabs to spaces.

 

SQL Server Management Studio ( SSMS )

Let us review SSMS Toolings as it relates to tabs and spaces.

 

Outline

  1. Editor
    • Editing
      • Choose Tabs or Spaces
    • Selected Text
      • Convert “Tabs to Spaces” and “Spaces to Tabs
    • View White Space

 

Editor

Editing

Choose Tabs or Spaces

Outline
  1. Access Menu
  2. Choose Menu Items
    • Tools \ Options \ Text Editor \ Transact-SQL \ Tabs
  3. Please Choose
    • Tab
      • Tab Size
        • We kept as 4
      • Indent Size
        • We kept as 4
    • Insert Spaces or Keep Tabs
Images

 

Selected Text

Tabify Or Untabify Text

Outline
  1. From the editor, select Text and keep selected
  2. Access Menu
  3. Choose Menu Items
    • Edit \ Advanced
      • Tabify Selected Lines
      • Untabify Selected Lines
Images

 

 

View White Space

Outline
  1. From the editor, select Text and keep selected
  2. Access Menu
  3. Choose Menu Items
    • Edit \ Advanced
      • Toggle “View White Space”
Images
Image – View White Space – No

Image – View White Space – Yes

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s