SSMS SQL Editor "shortcut in the current line"

Question

SSMS SQL Editor "shortcut in the current line"

JediSQL

SSCrazy

Points: 2118
More actions
August 17, 2020 at 9:00 pm

#3781130

My fingers were fumbling at the keyboard in the SSMS SQL query editor window, and I ended up with a little [->] icon in the gray gutter bar on the left (where break point icons show). I knew approximately the keys I was working with and searched the Web. On this page:
https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts?view=sql-server-ver15
I found this:
Set or remove a shortcut in the current line: CTRL+K, CTRL+H
Does anyone know what "a shortcut in the current line" is for ?
Thanks in advance,

Sincerely,
Daniel

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398908 More actions · Answer 1

Great question. Not a clue. I just tried it out. It puts a weird looking arrow in there. Several clicks in and around it yielded nothing. Hmm...

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Grant Fritchey SSC Guru Points: 398908 More actions · Answer 2

It's for the Task List. The short cuts act as markers there. Got the answer from Twitter.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

JediSQL SSCrazy Points: 2118 More actions · Answer 3

Thanks,

I did a little research on the Task List, and it seems like it is something that has been broken since SSMS 2017: Task List seems incomplete.

My coding often involves writing /*TODO: blah blah*/ comments in my code. Having a short cut list to those does seem helpful.

Oh, there is a SQL Server Central topic, too:

SSMS version 17.x Task List Window

https://www.sqlservercentral.com/forums/topic/ssms-version-17-x-task-list-window#post-3781520

Sincerely,
Daniel

Grant Fritchey SSC Guru Points: 398908 More actions · Answer 4

I'd probably lean heavily towards using tasks defined through whatever tools we're tracking bugs and other work in. Especially since those tools usually can be correlated to source control. Since all changes go through source control, I can track that work as I make the changes. That way, the less than complete solution, can be ignored. Still, having a way to go right to the bit you're working on is kind of nice.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

JediSQL SSCrazy Points: 2118 More actions · Answer 5

It looks like Microsoft is moving towards getting rid on Task List. In SSMS 18.6 it is not on the View menu anymore, though it can be accessed by Ctrl-Alt-K. Ctrl-K, Ctrl-H still adds and removes shortcuts from a line of code. In Visual Studio 2019 database projects, it still works like SSMS 17.x.
Task lists in SDLC/ALM systems is for big level tasks at the team level. It would be a mess if every team member put their little notes to self in there.

Sincerely,
Daniel

JediSQL SSCrazy Points: 2118 More actions · Answer 6

Oh, yeah, I'm in another thread on this:

Not able to create tasklist in Sql Server Management Studio

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4a160d5f-b390-4583-bab4-eb7596729088/not-able-to-create-tasklist-in-sql-server-management-studio?forum=sqlgetstarted&prof=required

Sincerely,
Daniel