Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
With the Editor you can format your code with indenting, hidden text, URLs, and so forth. You can also auto-format your code as you type by using Smart Indenting.
You can choose three different styles of text indenting. You can also specify how many spaces compose a single indentation or tab, and whether the Editor uses tabs or space characters when indenting.
On the Tools menu, click Options.
Click Text Editor.
Click the folder, and select All Languages to set indenting for all languages.
Click Tabs.
Click one of the following options:
None. The cursor goes to the beginning of the next line.
Block. The cursor aligns the next line with the previous line.
Smart (Default). The language service determines the appropriate indenting style to use.
Note
Some languages do not offer all three indenting options.
On the Tools menu, click Options.
Click Text Editor.
Select the folder for All Languages to set indenting for all languages.
Click Tabs.
To specify tab characters for tab and indent operations, click Keep tabs. To specify space characters, select Insert spaces.
If you select Insert Spaces, enter the number of space characters each tab or indent represents under Tab Size or Indent Size, respectively.
Select the text you want to indent.
Press TAB, or click the Indent button on the Standard toolbar.
Select the text you want to unindent.
Press SHIFT+TAB, or click the Unindent button on the Standard toolbar.
On the Tools menu, click Options.
Click Text Editor.
Click All Languages.
Click Tabs.
Click Smart.
Note
The Smart option is not available for some languages.
Select the text whose white space you want to convert to tabs.
On the Edit menu, point to Advanced, and click Tabify Selection.
Select the text whose tabs you want to convert to spaces.
On the Edit menu, point to Advanced, and click Untabify Selection.
The behavior of these commands depends on the tab settings in the Options dialog box. For example, if the tab setting is 4, Tabify Selection creates a tab for every 4 contiguous spaces, and Untabify Selection creates 4 spaces for every tab.
You can use commands to convert text to all uppercase or lower case.
Select the text you want to convert.
To convert text to uppercase, press CTRL+SHIFT+U, or click Make Uppercase on the Advanced submenu of the Edit menu.
To convert text to lowercase, press CTRL+SHIFT+L, or click Make Lowercase on the Advanced submenu of the Edit menu.
Note
For a complete list of keyboard shortcut keys, see SQL Server Management Studio Keyboard Shortcuts.
You can create and display clickable URLs in your code. By default, the URLs:
Are underlined.
Change the mouse pointer to a hand when you move over them.
Open the URL when clicked, if the URL is valid.
On the Tools menu, click Options.
Click Text Editor.
To change the option for only one language, click that language folder and then click General. To change the option for all languages, click All Languages and then click General.
Select Enable single-click URL navigation.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayTraining
Module
Format alphanumeric data for presentation in C# - Training
Explore basic methods in C# to format alphanumeric data.