282 results found
-
automatic insert table alias on columns
when typing a query have the table alias inserted before the column automatically. For example, in the query below, the t. will automatically get inserted before the column names after the table with an alias is entered.
Select t.column1, 1.column2
from tablename t
where t.column1 = @value22 votes -
Add the ability to disable intellisense integration in Visual Studio
Please add the ability to disable the intellisense integration in Visual Studio - I like the formatting options, but prefer the intellisense in VS. Currently, it's an "all or nothing" approach where I have to use SQL Complete Intellisense if I want the formatting.
3 votes -
Improve schema change detection - or provide manual refresh feature
I'm using the free edition. Edited my db schema via die diagram editor, but SQL Complete did not pick up schema changes. Menu only has "refresh suggestions" option but not "refresh intellisense/schema" which I saw mentioned in another user's post.
So, either improve the schema change detection in the free version, or provide a way for the user to refresh manually.
Thanks for a great product.2 votesDescribed problem was fixed right after adding this suggestion. We received a ticket via support system and didn’t notice the suggestion.
-
3 votes
-
Add the options to format DDL statements
Currently, the formatting options for DDL are rather limited. I would like to be able to control indentation of columns and braces in table definitions (to align the type declarations of the columns), as well as control over the structure of create index/constraint statements
3 votes -
Allow for a shared formatting file
In an office environment, it may be useful to use the same formatting file across multiple machines. This will be used on a read-only basis (but could be created by exporting it, so the manager can create or update the file).
Using a shared file rather than exporting and emailing the file to be imported would mean that changes made by the manager would be instantly reflected for all users in the dept.8 votes -
Auto-complete for Linked SQL Servers
We have a SQL environment that includes several linked servers and sometimes writing a quick investigative query to one of them is more conveniently done from the current context, rather than opening a new connection in SSMS. Some of my coworkers use Redgate's SQL Prompt which offers auto-completion for linked servers and I would like to see that functionality available in SQL Complete
15 votes -
Synchronize "Refresh Local Cache" with "Refresh Suggestions"
Guys,
Synchronize SQL Complete "Refresh Suggestions" command with built-in "Refresh Local Cache".Overwise, It's always needed to click both of these commands (first refreshes intellisense, sencond refreshes error highlighing)
20 votes -
6 votes
-
Format table and field names to be consistent with the database letter case
When formatting a statement:
SELECT sometable.fieldname AS something FROM sometable
SQL Complete KNOWS the proper case of the table and field names (as it allows you to autocomplete them as you're typing it in). So, why doesn't it alter the case of them once they're already in the statement?
If the table was actually SomeTable in the database, and the field was called FieldName, the "format" function should fix the statement like so:
SELECT SomeTable.Fieldname AS something FROM SomeTable
32 votes -
Snippets should commit on space/tab
Snippets are only committed when I press Enter, but I use space/tab much more often.
4 votesWe’ve added snippet commit on tab.
Automatic snippet expand on space seems dubious to us. -
Reverse order of ON clause
Auto-complete always enters an ON clause as:
SELECT * FROM Table1
INNER JOIN Table2 ON Table2.Value = Table1.ValueThis is really annoying to me. I would like an option to reverse the ON clause so it completes like this.
SELECT * FROM Table1
INNER JOIN Table2 ON Table1.Value = Table2.Value22 votes -
Intellisence on cross database queries
Show database objects when writing cross database queries.
SELECT t.*
FROM [dbName].[dbo].[table] t0 votes -
Different alias generation
For table name, for example, 'tMoneyCashOrder', auto-alias should be like 'tMCO', not "mco" like now. The first letter is often used to determine the type of object (table, view)
3 votesThe feature is implemented in SQL Complete v5.0. If the table name is ‘tMoneyCashOrder’, auto-alias will be generated as ‘TMCO’ or ‘tmco’.
-
Include column names after the where clause. If alias is present using alias.column name format
When using WHERE clause in select or update query, columns name don't appear even if alias.ColumnName is used e.g.
SELECT
*
FROM
Table t1
WHERE
t1.? (Columns should appear here)1 vote -
Do not show intellisense po when indenting code block by TAB
When I pressing TAB button with selected code block to tabify it - intellisense popup opening.
Please, open intellisense popup only if nothing selected.2 votesVersion 3.0 is on the site
-
Allow Table Aliases to be Uppercase without affecting the Table/View name case
I tried changing the Identifier to Uppercase to try to get the Table aliases to be uppercase but that made the tablename uppercase as well.
30 votesTry dbForge SQL Complete v.4.5 beta!
-
Autocomplete functions with braces
When autocompleting a parameter less function like say: getdate, include also the braces () and put the caret after the closing brace so you can continue typing without having to type the braces youself
When autocompleting a function with parameters, also automatically put the braces, but place the caret in between the braces (<caret here>) so you can directly start typing the parameter.
16 votes -
checkboxes to select what columns you want to select
when you need to select a column from a table for anyreason. have them listed with checkboxes so you can just selected the ones you want included and they will be insterted into your query.
17 votes -
1 vote
Version 3.0 is on the site
- Don't see your idea?