Data Warehousing and Business Intelligence

10 February 2016

Alt Key in SSMS

Filed under: Analysis Services — Vincent Rainardi @ 6:39 pm

The Alt key in SQL Server Management Studio, functions as “vertical mode”. If we press the alt button whilst clicking and dragging the mouse, we can select a vertical block of text like this:

Block KPI

When then press Tab to insert spaces, or press Delete to delete the word KPI from all 3 lines in one go.

After pressing Delete, we can type “Target” and the word Target will be inserted in all 3 lines in one go, like this:

Target

The vertical blue line is the cursor. When this blue line appear, we can press shift-left or shift-right to block text in “vertical mode”. Press shift-down or shift-up will extend/reduce the blocked text by 1 line, like this:

Shift-Right

When some text is highlighted like the above, we can find or replace any text, within just the selected area. To do that, just press ctrl-F or ctrl-H like this:

Find and Replace

Also, when some text is highlighted in vertical mode, we can drag them to the right or to the left (all 3 lines in one go), like this:

Dragging

When we want to type the same thing on many lines, press alt, highlight 1 character/column over many lines, and start typing, like this:

Typing multi lines

Hope this helps.

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: