64 results found
-
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 -
Server Color
There is server coloring in the project. But there are only a few colors I can choose. If I can do it like in SSMS Tool Pack, I can choose any color for the server
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 -
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.
-
AS keyword
Include a formatting option to "Always include AS keyword for aliases". The goal would be to change
SELECT
*
FROM
[dbo].[Table1] [T]into
SELECT
*
FROM
[dbo].[Table1] AS [T]Note the AS added to the FROM clause. This option could be global (Misc group?) or could be a separate option for each relevant clause (SELECT for field names, FROM and JOIN for table names, etc.).
1 vote -
Format rule for CREATE TABLE
Need a format rule for CREATE TABLE.
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.
-
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 -
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. -
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 -
1 vote
-
Status bar color (use the tab color)
I would like to see the status bar colored like the tab. The tab coloring is already implemented so it would be nice to sync with the status bar also.
1 vote -
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 -
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.
- Don't see your idea?