310 results found
-
Empty line management
There should be a global empty line management structure for formatting. It would be nice to see:
- Add empty line before/after keyword - Remove empty lines - Add empty line between statements
17 votes -
Add x blank line before and after as formatting options
I would like to have sometimes a blank line between segments of my SQL, for example before and after the UNION statements so it's easiter to see the different Select statements
1 vote -
1 vote
-
If user types a paren *immediately before* a paren, skip *past* the paren instead
AutoComplete suggestion: MS Visual Studio does this, you should too.
- Type in a function name: SQLComplete adds a full set of parentheses: SET X=myFunction()
- Type in function parameters: SET x = MyFunction(1,2)
- If user types closing paren, we have two, which is wrong. Current alternative is to right arrow or something to get past it.
- SUGGESTION: If user types a paren immediately before a paren, skip past the paren instead!
MS Visual Studio does this and it works great.
0 votes -
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 -
Extend Insert Highlight Occurences feature to show popup with column name in the values area
when typing out the values for an insert statement
SSMS should popup an infotip very much like when inserting parameter for functions in Visual studio C# code.
e.g. After typing the , (comma). SSMS should show a popup
Insert into Person.Address
(
AddressLine1
, AddressLine2
,City
,StateProvinceID
)
Values
(
,N''
,N''
,N''
, __________________________#
StateprovinceID int not NULL #
_________________________#
^ popUP
2 votes -
SELECT Results Generate INSERTS INTO Temp Table / Table Variable
How about a feature which would take a SELECT result, declare a Temp Table / Table Variable based on the schema of the result, and generate INSERT INTO statements?
I do this often when comparing data across disparate systems where the source data is scripted into a table variable to be compared in the destination system. I use a combination of CONCATs and a WHILE loop to handle the need for a trailing comma (if using VALUE), or trailing UNION if using SELECTs as insert into source.
1 vote -
align equals
I like the option to align assignments in SELECT, UPDATE, etc, but I don't like that the alignment happens after the equals sign. It's much neater and easier to read when each column is aligned with an equals sign for the assignment.
(It's for this reason we use equals for column aliases rather than AS)
3 votes -
Intellisense/Completion for UDTs
User Defined Types seem to have no intellisense or completion. Hovering over them shows no information about them. SQL Complete does not offer to complete the field list when inserting into them.
This is extremely annoying. Please add intellisense and completion for UDTs!
13 votesAdminDevart (_, Devart) respondeddbForge works with user types.
Could you please describe it in more detail?
-
Go To Definition should open a connection if one is not already open
Currently you get an error if the Object Explorer is not connected to the same server. Seems like SQL Complete could make that connection for us and save that step.
1 vote -
code preview when hovering a tab or session in the "Documents Sessions" window
Code preview when hovering a tab or session in the "Documents Sessions" window. I often have several tabs open at once and they are all called "SQLQuery#.sql" which doesn't help. Allow me to see what code is in the tab by hovering it, or ctrl+tab or like tabing through windows or hovering windows in the taskbar in Windows.
3 votes -
Performance when starting visual studio
When starting visual studio with SQL Complete, it takes 15 seconds more to open Visual studio.
Maybe you can change to load the data after visual studio is opened? That way the delay is not visible to the user.
3 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 -
Format SELECT columns. Alias on left, object on right separated by aligned " = ".
Format SELECT columns. Alias on left object on right separated by aligned " = ".
e.g.
SELECT
ThisIsMyFirstCol = a.Col1
, SecondCol = a.Col2
, AndTheThrid = a.Col3
, ForthCol = b.Col1
, FithCol = CASE WHEN a.col1 = b.col2 THEN 'A'
WHEN a.col2 = b.col3 THEN 'B' ENDFROM dbo.tableA AS a INNER JOIN dbo.tableB AS b ON a.Col1 = b.Col1
12 votes -
Automatically generate DROP <OBJECT TYPE> IF EXISTS statement
In a SQL script, I create several schemas, tables, and procedures. I'd like to have the ability to right-click an object name (in the editor), and select something like "Generate DROP IF EXIST".
The tool would understand the object type and automatically add the following to the top of the file:
DROP PROCEDURE IF EXISTS <SchemaName1.ProcName1>
DROP PROCEDURE IF EXISTS <SchemaName2.ProcName2>
DROP TABLE IF EXISTS <SchemaName1.TableName1>
DROP TABLE IF EXISTS <SchemaName2.TableName2>
GO
DROP SCHEMA IF EXISTS <SchemaName1>
DROP SCHEMA IF EXISTS <SchemaName2>13 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 -
format section after press tab to complete
when typing an insert statement (as an example), I get the prompt to "Press Tab to paste full INSERT statement". After pressing tab, SQL Complete will put the insert statement in there to the formatting rules specified.
There are situations where I do that and the insert statement is tabbed over to the right but the full statement pasted is over to the left. Could SQL Complete format it so that the paste is formatted where it should be? It would save me a format document request!
1 vote -
disable / autoexclude colums [v].IDENTITYCOL, [v].$IDENTITY from select
Exclude columns [v].IDENTITYCOL, [v].$IDENTITY from select when checking the table checkbox on the suggestion popup window
example:
SELECT [v].id, [v].name, [v].IDENTITYCOL, [v].$IDENTITY FROM table [v]3 votes -
add a "edit data from query"
Add a "edit data from query", on the left click, in the query editor, to open the same module as when "Edit top 200 rows" in the table list is selected.
1 vote -
format json output
Add an option to format JSON output with proper indentation and line feeds
2 votes
- Don't see your idea?