65 results found
-
Format rule for CREATE TABLE
Need a format rule for CREATE TABLE.
1 vote -
Display what PC an activation is against
Either display the hardware hash in the about box or show the computer name in the manage license web page
1 vote -
join
When typing "JOIN [start of table name]" I would like the suggestions shown by SQL Complete to be based on the foreign keys and [start of table name] instead as now, when it highlights the first table based on [start of table name].
Example:
in my database I have a UserAccount and a UserSecurityRole table that are joined by a foreign key so when I start typing
SELECT * FROM UserAccount ua
JOIN UserSQL Complete shows all tables starting with "User" but the one highlighted in the suggestions list i UserAccount instead of UserSecurityRole with a foreign key, so…
1 vote -
Show Est. row count in Table Tooltip at the TOP to avoid truncation
When hovering over a table name in the editor, show the Est. row count at the "top" of the tooltip rather than at the bottom, currently the tip runs off screen on tables with many columns, causing it to be invisible
1 vote -
SET instead of SELECT whenever possible
We use SQL Complete to format our SELECT statements. So the following
SELECT [aField] FROM [dbo].[aTable]
turns into
SELECT
[aField]
FROM
[dbo].[aTable]However, this stament is then also transferred from
SELECT @intVariable = 1
into
SELECT
@intVariable =1This is messy, so when we're not selecting from a table, we would like SQLComplete to format our that statement into
SET @intVariable = 1
In this case it all fits nicely on a single line again.1 vote -
Named Tabs
It would be great if you could name the tabs, not just when saving a query
1 vote -
indent case end
In the CASE statement, add "Indent END by 4 column(s)
1 vote -
Warnings for Execution should not warn on UPDATE/DELETE to Temporary Tables or Table Variables
Warnings for execution should not warn on Temporary tables or table variables.
Example:
UPDATE T
SET T.Description = V.Description
FROM @Problem1099BoxRows T
INNER JOIN APVouchers V ON T.APVoucherID = V.APVoucherID1 vote -
Space-align multiple column values within INSERT VALUES statement
-- view this with monospaced font
INSERT @t (A, B, C)
VALUES
(1, 2, 3),
(11, 22, 33),
(111, 222, 333),
(1111, 2222, 3333)1 vote -
Disable Data Loss warning for a specific Script
I love the new feature that warns before delete data without any where.
However when writing migration scripts and debug them it can be annoying because it pops up every time.
would be nice if this could be disabled for a script.
for example by using a comment like --disable warning--
1 vote -
1 vote
-
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
-
Automatically add terminating semi-colons to statements
Given that MS is going the route of eventually requiring terminating semi-colons on statements, it would be useful to have an option to do that for me.
1 voteWith dbForge SQL Complete v5.6.146, you can right-click in the SQL document and select ‘Insert Semicolons’ from the popup menu.
-
1 vote
-
Close SQL Complete connection to SQL Server when not being used.
When running sp_who2 I can see tasks for "dbForge SQL Complete" for each user running SSMS even when it's not doing anything. (I guess the connection is pooled between each request that the application needs to make?)
Anyway, our admins don't like to see all of these jobs just hanging around doing nothing, especially on our live servers. Any chance of turning off your connection pooling?
1 voteWe would like to let you know that we have released dbForge SQL Complete, v5.6 where the issue you reported is fixed https://www.devart.com/dbforge/sql/sqlcomplete/download.html
Thank you for your help in improving dbForge SQL Complete.
-
separate options for text case for tables and columns
I like to have separate options for setting the text case for table aliases and for column aliases.
Personally I want my table aliases to be in lower case and my column aliases not changed (or starting with initial caps, depending on the project I'm working on).1 vote -
Should have provision to configure Query Alignment
Should have provision to configure Query Format
like (Each column to be placed in separate Line,
Join condition in single Line,
etc.)
or
Indenting is missing in formating1 vote -
I can't give a custom format to a clausule UNION
I can't give a custom format to a clausule UNION
1 voteThis can be setup in the ‘UNION’/EXCEPT/INTERSECT’ section of the ‘Edit Formatting Profile’ window.
To open the ‘Edit Formatting Profile’ window, please perform the following:
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 and click the ‘Edit Profile…’ button. -
sorting the fields in a INSERT INTO statement in the same order as the SELECT statement of the query (or vice versa), taking into account t
Sorting the fields in a INSERT INTO statement in the same order as the SELECT statement of the query, taking into account the column aliases. Thus
INSERT INTO table
(columnA, columnB, columnC)SELECT foo AS columnB, columnC, bar AS columnA
FROM table2becomes
INSERT INTO table
(columnB, columnC, columnA)SELECT foo AS columnB, columnC, bar AS columnA
FROM table2With a few columns it's no big deal to do it manually but with 20 columns it is.
Displaying a hint if columns are missing is also welcome.1 vote -
Provide an option to insert the 'AS' clause before aliases
I want to be able to insert the 'AS' clause before all aliases. Currently, SQL Complete does not insert the 'AS' clause.
1 voteThe ‘Automatically generate AS clause’ option is available in the ‘Alias’ section of the ‘Options’ window that can be invoked by selecting ‘SQL Complete → Options’ from the main menu.
- Don't see your idea?