Search Results in Grid Mode
Find all occurrences of your search string in the results in datagrid mode. I know I should and could do this in SQL but sometime it is handle to find the customers name in a large set of rows.
-
Greg commented
SSMSBoost has all sorts of features that operate on the result grid - find, aggregate (sum/avg/min/max/etc) which was really useful. I'd love to see this built into SQL Prompt. Jason is right, I could rewrite the query to return the values I'm looking for, but when I'm debugging sometimes it's helpful to find a particular record in a dataset. An example from today - I had a query that was returning correctly when I added a where clause to a table, but when I took it off (as the code would run in production) it returned (correctly) ~1,000 rows. I needed to find my sample data in that dataset.