306 results found
-
Alias comprise of the first two letters of table name
Would it be possible to add an option allowing for the alias to comprise of the first two letters of the table name rather than the first, for example:
dbo.position po
dbo.product pr6 votes -
Do Api command lines
To do Api command lines to execute the rules of the SQL Complete in a batch process. Also provide Api command lines give the possibility to create a javascript process to run a task each 2 hours (for example) in the repository of the sp's (for instance). If there is an error an e-mail will be sent to responsible of that sp
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 -
Implement ability to show objects in completion list only for specific databases
It would be nice to have an option to limit intellisense to either 1) the currently selected database or 2) a pre-defined set of databases. That way I don't have irrelevant database object names showing up in the intellisense pop-up.
1 vote -
Few more features
- After where or any other keyword, add a space
- If there is a list of suggestions (ex. for a field name, user should be able to select the last item by the down arrow)
- When one bracket is put, complete the other bracket and bring the cursor point to the middle
The same suggestion as above for the Begin - End (Also the Begin isn't auto complete)
1 vote -
When hovering over SP, display whether it has default values or not
Is it possible that when i hover over an SP, that i see if the parameters have default values or not?
1 vote -
Integrate with CodeCompare Free/Pro
Permitir comparar dos archivos o más objetos por selección; de bases de datos diferentes o de servidores diferentes.
3 votes -
Ident guide lines
Visualize the ident guide lines in the document.
4 votes -
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 -
Add vertical scroll bar to 'Quick object info' hint
Add vertical scroll bar to 'Quick object info' hint to make it possible to view the complete list of the table columns (table with more than 60 fields).
22 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 -
Improve "Execute current statement"
The current statement is not executed when it is commented out.
If i have the following query and attempt to execute it, SSMS says "Command(s) completed successfully.". The query is not actually executed.
-- select * from table11 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 -
copy to code
After I create a query in Sql Management Studio, what I usually do is copy the sql to code. I'm programming in c# and when I copy the sql to code, I must add parentheses at the start and the end of each line with also a '+' character to tells compiler to combine line.
A very beautiful feature would be to add a shortcut to copy the sql into the clipboard but with these parentheses and '+' character. After that, I just simply have to paste it without error directly into my code.
Another very beautiful feature would be…
14 votes -
Ability to clear results of Output window
It would be nice to be able to clear the results of the output window
1 vote -
Navigating to errors on formatting from Output window
When running format document and there are syntax errors, it would be great if you could double click the error in the output window and it would take you to the error.
1 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
- Don't see your idea?