275 results found
-
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 -
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 -
1 vote
-
Format rule for CREATE TABLE
Need a format rule for CREATE TABLE.
1 vote -
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
-
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
-
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.
-
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
-
Geography / Geometry Suggestions
Add support equivalent to the XML suggestion capabilities, but for the Geography and Geometry data types.
5 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.
-
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 -
Extend Highlight Occurences feature to INSERT SELECT construction
You have a very convenient feature Highlight Occurences to highlight all field or variable occurrences.
I would suggest you to make a highlighting of the corresponding value in the INSERT SELECT construction when navigating to a field.
In the following example, when navigating to the 3rd column, the corresponding value should be highlighted in the SELECT clause too:
INSERT INTO table (clm1, clm2, clm3, clm4, clm5)
SELECT 0, 1, 5, 0, 311 votes -
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 -
Refactoring: Change variable name in procedure
refactoring (change a variable name in a procedure for example, and have that change propagate throughout the procedure for each instance of the variable)
3 votesThe feature is available in SQL Complete v5.0!
-
Oracle style formatting for SQL statements
It would be great if we could have the Oracle style SQL formatting option, where keywords are right justified and the arguments are left justified. Like below:
select col1, col2, col3
from dbo.tableName
where col2 = 1233 votes
- Don't see your idea?