231 results found
-
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. -
cte
It looks like the execute current statement command can't deal with CTEs which is a bit annoying. Overall this is great though, makes using SSMS much better.
1 vote -
intellisnese for temp tables
I was ready to buy but intellisnese on temp tables is a must
1 vote -
Fix erroneous formatting error when formatting DBCC show statistics
When "Format Selection" operates on the following T-SQL code an error is generated.
DBCC SHOWSTATISTICS(N'dbo.charge', _WASys000000060DAF0CB0)
WITH DENSITY_VECTOR;The error:
- C:\Users\jhatt\Documents\SQL Server Management Studio\SQL Server Projects (all versions)\CommonQueryTuning\Part01Module_02\07 Density Vector with an unknown runtime value.sql: Error (22,12): 'Identifier' expected
- C:\Users\jhatt\Documents\SQL Server Management Studio\SQL Server Projects (all versions)\CommonQueryTuning\Part01Module_02\07 Density Vector with an unknown runtime value.sql: Error (20,13): ''as'' expected
1 vote -
1 vote
-
Built-in DataType Case option is being ignored
In SQLComplete 5.5.159, the Built-in DataType Case set to lower, but all types are automatically converted to upper case
1 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. Navigate to the ‘Text Case’ node and select the options you need. -
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.
-
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.
-
Support for multiple SSMS instances
When running two or more SSMS instances there is an error that pops up pretty often saying: "Access to the path 'C:\Users\FFlintstone\AppData\Roaming\Devart\dbForge SQL Complete\docsessions-journal.db' is denied."
1 voteThis issue is fixed in dbForge SQL Complete, v5.6.169 https://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Increase thickness of the window coloring line
Please add an option to control the thickness of the coloring line of the tab for different servers. The line on the top of the screen is very thin on high definition monitors, so it is difficult to see.
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 -
checking update failed
The checking update menu in sql complete may point to a HTTP url and currently devart.com is only available via HTTPS protocal. It let the update checking 100% failed with network error message: cannot connect to remote server.
1 vote -
SQL XML fucntion value is changed to Value (uppercase V) when formatting a document. This is not valid SQL
Formatting document should not change value to Value in an XML SQL query. Value is not a valid function
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 -
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 -
Execute to Cursor change to not check beyond cursor position
Currently you cannot use Execute to Cursor with a CTE. Error is returned as the process looks beyond the cursor.
example:
with cteone as
(
select a.field
from table1 a
)
select * from cteone <-- Cursor placed here and execute to cursor returns error,ctetwo as
(
select b.field
from table2 b
)
select *
from cteone1 voteThe script is invalid.
The correct parsing of CTE statements on Execute Current Statement is supported.
-
Meaningful parameter names for system functions
Example: suggestion for CAHRINDEX function should look like (expressionToFind , expressionToSearch) instead of (expression1, expression2)
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 -
indent case end
In the CASE statement, add "Indent END by 4 column(s)
1 vote -
configure Tabs Color for [Server]\Database
I have multiple databases on a server some are Test & dev servers, some are Prod. It would be nice to color based upon [Server]\Database. instead of one color for each server.
1 vote
- Don't see your idea?