278 results found
-
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 -
1 vote
This is the native feature of SSMS.
-
Named Tabs
It would be great if you could name the tabs, not just when saving a query
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 -
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 -
Alias CTE like tables
When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue
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 -
Keep the comments when formatting procedures!
Keep the comments when formatting procedures! IT can't be that all comments are removed by the formatting process! That happens to my code when I execute ALTER PROCEDURE!
OR: Give me the option to NOT format my code! I use the Express Version.1 vote -
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 -
Bug in SQL Complete when using spatial functions
I have a Problem with spatial functions when using SQL Complete.
SSMS 18.12.1 always hangs when geompetry functions are used in query editor and SQL Code Completion is turned on.
eg.: geometry::STPointFromText(( ...
I have to kill ssms in Taskmanager to recover.Please fix this, otherwise SQL Complete is a great tool. SSMS feels broken without it.
1 vote -
Add Execution Warning if no WHERE clause
If a person tries to execute a SQL script without a WHERE clause, it would be nice if SQL Complete would display a warning. This would eliminate issues with accidentally updating all records in a table because a where clause was not specified.
1 vote
- Don't see your idea?