275 results found
-
Add extended properties for columns in quick info window for table
When navigating the mouse cursor to a table, display extended properties in the quick info window.
3 votes -
Execute statements to cursor position
I would like to have option(keyboard hotkey) that can execute all statements which are above of cursor position including statement with current cursor position.
I would call this feature: "Execute query to cursor position"
I think its very helpful while debugging/creating stored procedures or sql queries
2 votes -
JOIN FIELDS SUGGESTIONS - Enable TAB acceptance of first suggestion
When PRIMARY and FOREIGN KEYS share the SAME NAME according to best practises allow the JOIN suggestion to be immediatly pick up with TAB.
Most of the times the good suggestion comes at top on the list and one can allways navigate to a better one if this is the case3 votesThis can be achieved as follows:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘List Members’ branch in the ‘Options’ window.
3. Select the ‘Tab’ option.
4. Click ‘OK’. -
Support formatting for @tbl_Table
Please add support for formatting table variable like other table similar format:
Declare @tbl_MyTable Table (
Id int,
Code nvarchar(50)
)1 vote -
Ability to copy a value in the grid along with the column it belongs and formatted for WHERE clause
For example, let's assume this is the output from a query:
id name role
1 Torn ADMIN
2 John CLERK
3 Adam SUPERI would like to click on say John, and press a combination of keys (CTRL+Q for example) and have the ability to copy in the clipboard the following: name = 'John'.
In addition, if I select multiple cells, say I select all Adam and SUPER cells, and press the combination of keys, it should copy:
name = 'Adam' and role = 'SUPER'16 votes -
1 vote
-
When formatting document or selection, leave cursor on same line on screen
When formatting a document or selection, the line with the cursor is moved as far down on the screen as possible. I would like it to stay on the position on the screen.
As it is now, I have to "search" for the cursor every time I have formatted and often I will have to scroll, since I will typically want to see the code below the cursor.
9 votes -
ability to create some snniped
ability to create some snniped
1 voteThe Code Snippets feature is available in the fully featured 30-day Trial version of the Standard Edition of dbForge SQL Complete http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Autocomplete picklist wider
If would be great if the autocomplete pick list was resized sqlcomplete would remember this size change.
4 votes -
Format rule for CREATE TABLE
Need a format rule for CREATE TABLE.
1 vote -
The first entry in the suggest list dropdown should chosen automatically
The first entry in the suggest (intellisense) list dropdown should chosen by default.
This will speed up my typing as the 1st word at the top is typically is the best fit, but to chose it I need to move my mouse or the down arrow key to actually choose it.23 votesThis is governed by the option ‘Select items in the list if a user input is expected’ that is in the ‘List Members’ branch of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
-
Implement code formatting for Merge statements
Currently, the SQL Formatter has absolutely no options for Merge statements, and they are not formatted very nicely at all.
Please provide options for formatting all the aspects of Merge statements:
- Using section
- WHEN MATCHED section
- WHEN NOT MATCHED sections
- Output sections
Also, if possible, provide the option to have these sections use the same formatting as standard statements. E.g. Update statement in When Matched section uses standard update format, etc.
6 votesThis feature is implemented in dbForge SQL Complete, v4.8 http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Format first row in stacked list with leading space
You should be able to add a leading space for the first row in a stacked list with leading commas, so the column names would be evenly aligned.
8 votesThis feature is implemented in version 4.8 and applies when the ‘Stacked List → Place comma before item in stacked list’ and ‘SELECT → Select List → Line break before first column’ options are selected in the ‘Edit Formatting Profile’ dialog.
-
3 votes
-
Intellisense for table definition should use INFORMATION_SCHEMA data.
It seems the current implementation parses a CREATE TABLE statement and only shows the columns defined there when you hover over a table name. Columns added later via ALTER TABLE statements do not show up. The intellisense list should be built by querying the CURRENT table structure via INFORMATION_SCHEMA.COLUMNS in order to show all columns.
3 votesPlease check that you have selected the ‘Automatically refresh suggestions cache’ and ‘Detect changes on a server before refreshing suggestions cache’ options in the ‘Text Editor → Code Completion → General’ section of the ‘Options’ dialog box that can be opened by selecting ‘Tools → Options’ from the main menu.
Please also check that the altered object belongs to the database selected in the ‘Database’ drop-down menu on the ‘SQL’ toolbar.
-
Geography / Geometry Suggestions
Add support equivalent to the XML suggestion capabilities, but for the Geography and Geometry data types.
5 votes -
Indent table after FROM
Treat FROM and JOIN as equals be able to indent table names ex:
FROMTableA
JOIN
TableB6 votes -
CrLf after last GO
I'm always adding to batches and no blank line at EOF frustrates the heck out of me.
4 votes -
Ability to change the keyboard shortcuts used in SQL Complete
Add the ability to modify the keyboard shortcuts used for certain SQL Complete features. Reason for requesting this is due to the fact that certain keyboard shortcuts chosen by SQL Complete may clash with shortcuts used by other third party tools.
In my case, the format selection shortcut, Ctrl+K, Ctrl+F is used in the SSMS Tools Pack add-in I have installed. So when I try to use Ctrl+K, Ctrl+F I get the SSMS Tools Pack resultant of the shortcut, and not the format selection option of SQL Complete.
3 votesThis is available in VS/SSMS 2012 or higher.
-
format selection by a profile I select
I'd like to select some code, right click, and have menu choices to match my profiles such as:
Format Selection Horizontal (tight)
Format Selection Vertical (spacious)6 votes
- Don't see your idea?