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