Can I add a bookmark in query window so that could be easier to go back?

Question

Can I add a bookmark in query window so that could be easier to go back?

adonetok

SSCrazy Eights

Points: 8395
More actions
September 12, 2012 at 12:48 pm

#264059

Can I add a bookmark in query window so that could be easier to go back?

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

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Does this image helps?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 2

Not to my knowledge, however if you right click on the tab heading you can split it off into a new vertical/horizontal tab group. Also if you save the query and then go to File-> Recent Files -> you will see it in your list of recently opened files. If it happens to be currently open in a query window and you select the file SSMS will shifts focus to it. If it isn't open then of course it will open it.

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

adonetok SSCrazy Eights Points: 8395 More actions · Answer 3

Thank you.

Sometime when I modify a very longer store procedure I want to quick back to the position of store procedure where I read.

I added line number now to go back for that line number if I need.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Edit -> Bookmarks -> Toggle bookmark

Then to navigate between bookmarks Edit -> bookmarks -> Next bookmark in document or Edit -> bookmarks -> Previous bookmark in document

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 5

Luis Cazares (9/12/2012)
Does this image helps?

+1

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)