275 results found
-
Bug: Line breaks removed before comments
New lines are removed between a parentheses or a comma and a comment.
see sample below.
Select * From(
Select 1 a,
--comment after comma - rows above removed 2 t --comment after field - rows above not removed , --sdf 3 g) /*comment after parentheses - rows above not removed*/ a5 votes> New lines are removed between a parentheses or a comma and a comment.
> see sample below.
> Select * From(
> Select 1 a
> ,
> —comment after comma – rows above removedThis issue is fixed in the latest build 4.0.78: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
> 2 t
> —comment after field – rows above not removed
> ,
> —sdfThis issue is fixed in the latest build 4.0.78.
> 3 g)
> /comment after parentheses – rows above not removed/
> aSuch behavior is currently by design. Though, you can carry this issue over to a new suggestion.
-
Geography / Geometry Suggestions
Add support equivalent to the XML suggestion capabilities, but for the Geography and Geometry data types.
5 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 -
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 -
4 votes
SQL Complete v2.0 is on site!
-
ctrl-space on built in function params should not cause hangs
If I enter ...
select replace(
and then I type ctrl-space (ie. give me the params available) Server Studio hangs.4 votes -
Snippets should commit on space/tab
Snippets are only committed when I press Enter, but I use space/tab much more often.
4 votesWe’ve added snippet commit on tab.
Automatic snippet expand on space seems dubious to us. -
Shortcut for partial selection
I'll be very glad if I could select a partial script in smart way and then run it with CTRL + SHIFT + E shortcut. The separator should be 2 blank lines, one at the top and one at the bottom of the script, and yes, I'm a shortcut addict. thanks a lot guys!
4 votes -
4 votes
-
4 votes
-
Ident guide lines
Visualize the ident guide lines in the document.
4 votes -
INSERT statement formatting
We need extra control of the formatting of various statements, e.g INSERTs. We like to have our INSERT statements formatted like:
INSERT INTO dbo.Test
(
UserID
, Name
, IsDeleted
)
VALUES
(
0 -- UserID - INT NOT NULL
, '' -- Name - VARCHAR(32) NOT NULL
, DEFAULT -- IsDeleted - BIT NOT NULL
)but we can't even get it close
4 votes -
Intellisense casing
I've entered this once before and was told that the latest version had fixed it. Finally got to downloading the current standard version (4.0.61) and it had not.
The issue is that there used to be an option in prior versions (3.x) that let you select the case of inserted key words and functions. This option was removed and now everything is inserted in all capitol letters. Either bring back the option or use SQL Management Studio's "Casing for built-in function names" IntelliSense setting.
4 votesPlease perform the following actions:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select a profile.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Expand the ‘Text Case → Identifier Case’ node.
6. Select the ‘Do not change’ option.You can also change the other settings under the ‘Text Case’ node.
NOTE: The latest build of dbForge SQL Complete is 4.0.69: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Add SQL type at end of tooltip
The tooltip on local declarations now includes the type (INT, BIGINT, etc.), but the column tooltips do not. Those are the ones I'm usually more interested in, and save me from having to look them up.
4 votes -
INSERT: Stack values on a row basis
It would be nice if INSERTs could have the VALUES stacked on a row basis. E.g.:
INSERT table (col1, col2)
VALUES (''val1", 2)
, (''val3", 4)
, (''val5", 6)4 votes -
Enhancing Execute-Current-Statement with Execute-Current-Selection
I love SQL Complete's execute-current-statement functionality. I think it would greatly enhanced if it would automatically execute highlighted code. This could be a simple check: normally just execute-current-statement if no code is highlighted, but do a default SSMS execute (normally F5) if code has been highlighted.
I know I could always hit F5 but I think having both under the same keyboard shortcut would be very helpful. I never realized how useful it was until I began switching back to SSMS from Toad.
4 votes -
CrLf after last GO
I'm always adding to batches and no blank line at EOF frustrates the heck out of me.
4 votes -
Autocomplete picklist wider
If would be great if the autocomplete pick list was resized sqlcomplete would remember this size change.
4 votes -
Add type into into Tooltip for table column
It would be very usefull if tooltip (OnMauseOver) for column name in select would also provide info about column type, for example
[table].[column](column) => [table].[column](column, int)4 votes -
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
- Don't see your idea?