141 results found
-
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 -
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 -
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.Col112 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 -
Refactor - Qualify Objects
Offer refactor option that fully qualifies object names with schema. I know the option is there to do this when typing, ensuring aliased/qualified names. However, one feature in SQL Prompt from RG that is pretty amazing is the option to "refactor-qualify", and it will parse all the object schema names and ensure your proc/table/view/etc calls have the schema name in front of them. This is considered a good practice, but doing manually is very time intensive.
16 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 -
format json output
Add an option to format JSON output with proper indentation and line feeds
2 votes -
Add option to adjust font on intellisense
No option to enlarge font. font size on intellisense is too small.
3 votes -
Add 'BEGIN TRAN' and 'ROLLBACK TRAN' to the suggestions list
The suggestions list already has 'BEGIN' and 'ROLLBACK' but does not have 'BEGIN TRAN' and 'ROLLBACK TRAN'. I use these a lot and it would be great if they were added.
1 vote -
Add an option to group database entities by schema rather than flat alphabetical.
Add an option to group database entities (tables, views, stored procedures, etc.) by schema rather than flat alphabetical. Click +/- sign to expand or collapse schemas.
1 vote -
1 vote
-
Add column names to VALUES list for INSERT INTO statement generation
When generating the INSERT INTO statement after typing INSERT INTO [TableName] and hitting tab, it would be helpful in the VALUES list, in addition to showing the default value, if the column name was included. For example -
INSERT INTO Users
VALUES (DEFAULT /ID/, '' /FirstName/, '' /LastName/)This way, for wide tables, you don't have to count column to keep track of which column you are working with.
2 votes -
Virtual Folders for Database Objects In SSMS
The ability to add folders in SSMS for database objects. I understand these folders would only be virtual.
I know of one addin that has this feature. www.sqltreeo.com
43 votes -
group by formatting
replace "indent GROUP BY Phrase" with 2 options:
1) "Indent GROUP BY Keyword"
2) "Indent GROUP BY columns"the current options will now allow for formatting flexibility as it does for the where keyword/condition
1 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
73 votes -
SQL format selected text for visual studio
My company uses SQL code embedded into xml documents which is edited in visual studio, so to format the entire files would be bad. The sql formatter in SSMS is outstanding. It would be nice to be able to format just a selection of text inside visual studio with the sql formatter using my setup profile
1 vote -
in visual studio, right click on table to select top 1000 rows
in the ssms object explorer, many of us regularly right click on tables to select top 1000 rows, which opens a new query window with an editable query script. visual studio's sql object explorer has no such functionality besides view data which forces you into a designer-based edit mode.
11 votes -
Smarter subquery intellisense
It would be nice to have smarter subquery intellisense that works like the joining intellisense that suggest matches based on column names.
E.g.
SELECT * FROM Users WHERE EXISTS (SELECT 1 FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID AND UserRoles.RoleID = 1)E.g.2
E.g.
SELECT UserID, UserName, (SELECT COUNT(1) FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID) AS NumberOfRoles FROM Users3 votes -
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
0 votes -
Notifications pane
Currently SQL Complete notification (like "Uncommitted transaction" and "Query execution completed") show up and disappear. It would be great to have them on a panel similar to "Document Sessions", so you can review them later.
1 vote
- Don't see your idea?