272 results found
-
Easy goto definition and graphical position of errors and search
Similar to power tools for visual studio 2010: Pressing Ctrl + Click to go to the definition of the element. Also implement the sidebar where you graphically visualize the position of the matching elements and code errors.
6 votes -
Mark cells in results panel
I want to be able to mark cells in the results panel. I often have SSMS open on one screen, and some spreadsheet or notepad open on another. I can select the cells, but then that selection is no longer visible once I go to the other window. I should be able to change the background color or a cell in the results pane by right clicking, and/or keyboard command.
3 votes -
Checkbox next to fields in the Table Fields Pop-Up
- Click the checkbox of multiple fields of table joins when the table field pop-up is visible. 2. Auto create the field listing (with alias) in order of clicked when the pop-up is closed/dismissed.
1 vote -
Automatic Formatting of "TableName.Value AS Alias"
If you have a field name "Value" then automatic formatting mis-interprets this if it has an alias.
Formatting:
SELECT TableName.Value AS Alias
FROM TableNameBecomes:
SELECT TableName.Valueas Alias
FROM TableNameInstead of
SELECT TableName.[Value] AS Alias
FROM TableName1 vote -
Auto parsing and delimiting IN clause values
Auto parsing and delimiting IN clause values. As an app developer, many a times I find myself dealing with lengthy IN statements and would have to first paste my IN values in excel, run a script to add single quotes when values are strings and delimit each with a comma, then paste the result back into Management Studio and Enterprise Manager....e.g select * from table where col IN ('A', 'B',...)...basically your add-in with format the data once I paste into the IN...if column before the IN is string value, then it add quotes to the values and delimit and add…
1 vote -
Option to reorganize FROM clause so that inner join and left join stay the same, and right join changes to left join
the original sql statment:
SELECT *
FROM T1 RIGHT JOIN T2 ON T1.ID1=T2.ID1after reorganize
SELECT *
FROM T2 LEFT JOIN T1 ON T2.ID1=T1.ID13 votes -
Select from table popup command
When I click right mouse button over table or view identifier in some query, I'd like to see a command 'Execute a query for the table in new document'.
1 vote -
For any new subquery nesting level I would also suggest increment the indent from the previous query, not all at same level.
For any new subquery nesting level I would also suggest increment the indent from the previous query or subquery level, not all at same level.
1 vote -
alias second table reference
Automatically alias a second reference to a table even if "generate alias on commit" is not enabled
4 votes -
Pivot Columnar / Vertical Tables to Tradiational Row-type tables
I have looked high and low for product that will meet a need that I often have; from the number of posts that I find on the net many others have as well.
More and more, with the increase in the amount of data being collected and queried, data warehouses, BI software, using columnar tables (sometimes referred to as a vertical data structure) makes more since. Vertica DB and Terri Data use this structure natively.
However, it often is necessary to convert (or pivot) the data to a traditional horizontal, row-based format. In SQL Server as well as Oracle, and…
12 votes -
Expand contect menu "Generate Script As" with an "As-Is" option.
This would enable easy execution of scripts generated by another script. Preferably with an extra "Execute in new tab" option.
I use this method very often to automate my DBA work. Now it's a 3-4 step procedure, this idea will make it into a one-step thing.0 votes -
Formatting option for BACKUP/RESTORE commands
I like BACKUP/RESTORE commands formatted so that all the options (especially MOVE options) are on separate lines in order to enhance readability.
0 votes
- Don't see your idea?