282 results found
-
default suggestion even if containing SQL keyword
Please change the default selected suggestion in the dropdown so that columns in a user table take precedence over SQL keywords.
For example:
When a column in a user table begins with the same word as a SQL keyword (for example the field name "Monthly") -- the default selected suggestion when you type the word MONTH jumps to the "MONTH" keyword instead of staying on "Monthly"Code example:
CREATE TABLE #MyTable (Monthly BIT)
SELECT * FROM #MyTable WHERE M --selection stays on "Monthly"
SELECT * FROM #MyTable WHERE Mo --selection stays on "Monthly"
SELECT * FROM #MyTable WHERE Mon --selection…3 votes -
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 -
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 -
table function hint shows wrong parameters
When selecting from a table function the tooltip shows the return columns along with the parameters at last, which is super confusing.
3 votes -
1 vote
This is the native feature of SSMS.
-
Select and copy from Execution History results
Now it is possible copy all script from Execution History results (to clipboard or new window).
But sometimes it is required to copy just part of the code.
It is possible to select code in Execution History result window, but not possible to copy it.3 votes -
Execution History by server
Filter execution history by server that the code has been executed on.
3 votes -
Table alias gets converted to uppercase
When using a table alias of "u", all new instances becoming capitalized incorrectly.
Please see attached gif:
https://ibb.co/fr9LcH12 votes -
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 -
De-couple execute-current-statement functionality from code completion.
I like execute-current-statement functionality, but when I disable code completion then execute-current-statement functionality stops working.
3 votes -
1 vote
-
Add support for system stored procedures like sp_help
SQL Complete stops giving any table suggestions following a system command like sphelp or sphelptext. It should recognize "sp_help Customers" as valid and intellisense should continue working for any statement written below.
3 votes -
Code formatting for Merge Into "Values"
Merge doesn't have formatting for source table formed from values.
MERGE INTO [TargetTable] AS T USING (
VALUES (@UserId, @InternalId)) AS S
([UserId], [InternalId])
ON T.[UserId] = S.[UserId]
WHEN MATCHED ...5 votes -
Options group for logical operation enclosed in braces
Add an option group to the formatting profile for the logical operation enclosed in braces. This option group should include the following options:
Line break before opening brace
Line break after opening brace
Line break before closing brace
Line break after closing brace
Indent braces
Indent logical operation
Format braces around single comparison operation as in logical operationsAlso, make the same options group for the following predicates:
- EXISTS
- ALL
- ANY
- SOMEFor details, please the Devart forums http://forums.devart.com/viewtopic.php?f=33&t=35030
6 votes -
add a shortcut to do a "edit top 200 rows" on a selected SQL sql statement
Add a shortcut in the context menu to do a "edit top 200 rows" on a selected SQL sql statement
5 votes -
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 -
Support dynamic formatting using @SQLComplete tag to override a setting
There may be times when you would like to switch the formatting for a particular section of code because the global settings would not be most appropriate.
For example let's stay in SELECT statements you have "Stack Columns" checked with "Simple List" selected. This may be the desired format for 90% of the cases, however when there is a table with a large number of columns(50+), it could be more beneficial to view them on a single line so to see the query as a whole.
If you could add a comment before the query
--@Begin-SQLComplete Select-SelectList-StackColumns = True; Select-SelectList-StackColumns-Option=SingleLine…4 votes -
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 -
Remove square brackets
Microsoft's SQL Server Management Studio puts square brackets [ and ] around everything scripted or dragged/dropped from the Object Explorer to the scripting window.
I want a feature to remove all square brackets.
I currently have to use SQL Management Studio search/replace to remove the brackets, and rather have the removal performed when I format the code.
Jake
75 votes
- Don't see your idea?