logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Louis  
#1 Posted : Friday, January 11, 2019 11:04:21 AM(UTC)
Rank: Newbie
I'm continuously fighting with the standard search (CTRL-F) feature in SSMS.

My greatest grudge is that it disappears and removes all highlighted results as soon as I hit the Escape key (which I need to do allot to get rid of some code-completion boxes obstructing my view).

Only one search box is actually not enough. When I'm working on a large Stored Procedure there may be multiple things I'm interested in for example "Stock" and "@Quantity". Currently I can only choose one keyword (Column / Variable) to be highlighted by searching. It would be great if I could add multiple keywords with their own highlighting color. I might even want to save collections of them and reuse the same color scheme when working on certain bugs or features with similar aspects.

It would also be nice if the colors show up in the scroll-bar, but that's just a nice-to-have.
Andrei  
#2 Posted : Friday, January 11, 2019 6:34:22 PM(UTC)
Rank: Administration
Hello Louis,
Understood and looks really useful. Could you please describe 1-2 usage cases more detailed, how would you like to have this?
We are planning to upgrade our highlighter feature and your proposals are reasonable.
Just take what you have written above and describe in more detailed steps.
Thank you!
thanks 1 user thanked Andrei for this useful post.
Louis on 1/11/2019(UTC)
Louis  
#3 Posted : Saturday, January 12, 2019 12:48:28 AM(UTC)
Rank: Newbie
A use-case would be with a large stored procedure that either generates a report or performs some complex transaction. When doing some troubleshooting or bug fixing, there are often multiple columns or variables of special interest for the specific task. Today I had a case where I was trying to solve a bug in an SP that should trigger restocking when an order is inserted and the stock reaches under a specified level. The main part of the SP deals with inserting an order, so to find the code I'm looking for I search for "Stock" which is used in many places, then I select "@Quantity" and scroll through the document to find where these are used together. Unfortunately as soon as I move the cursor, the selected highlight disappears, and as soon as I hit escape the other disappears...

Another use-case would be with an SP that does some synchronization, for example xml is provided to the SP as an argument, and it should update a set of tables. Now an extra field needs to be added to the SP (and XML). An easy way to handle this is to pick a similar field already existing, and add the new field to all statements wherever the similar one already occurs in the SP. However the XML field may have a different name than the table columns, and different tables may have columns with different names that should be affected by the new field... In that case this task becomes allot more challenging, but a colorful multiple-search feature would greatly help.

I would also use the feature to discriminate between very similar fields, for example inc or ex VAT, purchase/sales price etc... These fields are used in multitudes of SP's and being able to color code them would relieve some strain on dyslectic eyes.

Here is a little mock-up of what I have in mind (the SP is not representative but it should give an idea):
Example UI
thanks 1 user thanked Louis for this useful post.
SujaiSparks on 1/15/2019(UTC)
Rss Feed  Atom Feed
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.