230 results found
-
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
-
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 -
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 -
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 -
If the word I manually type matches an autocomplete entry, apply the case in the AutoComplete to the typed word.
If the word I manually type matches an AutoComplete entry, apply the case in the AutoComplete to the typed word. This would apply to both reserved words and object names.
Example 1: I type 'sel' and wait a millisecond. 'SELECT' appears in the AutoComplete. I press [space] and SELECT is typed for me. Next, I type 'select' and press [space] without waiting. The word remains lower case.
Example 2:I type 'select * from peo' and wait a millisecond. 'People' (a table name) appears in the AutoComplete. I press [space] and 'People' is typed for me. Next, I type I type…
1 vote -
3 votes
-
Add a lowercase option in the SQL Formatter
Redgate has this, infact many of the online SQL formatters give you the option to have keywords, etc as lowercase, capital or uppercase.
Your product is reasonably priced against redgate.
But it's unusable if it makes all my keywords uppercase.
Thanks,
Jason1 voteThis can be setup as follows:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select the active profile.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Expand the ‘Text Case’ node.
6. Expand the appropriate subnode and select the ‘Lower’ radio button. -
Search the grid results pane
SSMS Tools Pack has a feature where you can right click on the results pane and click 'Search Grid Results'. Then you can enter some text and it'll find data in the results that match your search term. This is VERY handy.
11 votes -
Need ability to give intelliSense for store procedure parameter
I am big fan of this SQL Complete tool, it is really a good tool to help develop or build sql blocks. But one thing i notice that, currently sql complete is not providing intellisense for store procedure parameter. if it is providing this thing also than its really help full while building store procedure.
1 vote
- Don't see your idea?