140 results found
-
Create SQL Complete for Azure Data Studio
I would like to start using Azure Data Studio (ADS), as it has some features missing in SQL Server Management Studio. However, I am always using Format Document (^K,^D) and Format Selection (^K,^F). I would also miss SQL Complete's code snippets in ADS. I like and use SQL Complete so much that this is the main reason I won't yet use ADS. If you made a plugin for ADS I would buy it.
100 votes -
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 -
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 -
Add Export Query Result to Excel' option
It would be great if you could add a 'export query result to Excel' option in SQL Complete Thanks !
36 votes -
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 -
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 -
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 -
Option to right-align table aliases in SELECT list
Add an option to right-align table aliases in the SELECT list.
Here is an example:
SELECT
-> [alias]->-> -> -> =t.col1
-> ,[differentlen] -> =t.col1
FROM tablename t=t.col1 should be right-aligned and stay under each other.
12 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 -
Use object name as filename for "script object as"
When using the menu option "script object as..."
1) when creating the new file have the name of the object be the filename. That way it is much easier to find in the tabs of SSMS instead of just another SQLqueryxx.sql file. This would make it much easier to find it again after switching away from that document.2) have some option setup to make it always be a create and not an alter. When I use the command its so I can see what the object is, I don't want to accidentally modify it so create means sql server…
12 votes -
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 -
Intellisense for Synapse
We have started using serverless SQL Pool in Synapse, on top of a data lake.
In SSMS it behaves mostly as a "regular" SQL Server, however intellisense does not work at all with SQL Complete.
Please implement intelllisense for Synapse.10 votes -
9 votes
-
Auto-filling the GROUP BY
When I type group by and press the space bar to display "all non-aggregated columns" in the context menu. When I select this option, all columns that are not aggregated are added to the group with all their functions
9 votes -
Format: stack list table view format for JOINs
You already provide an option to align column aliases in a select statement by a table view option in the stack list.
how about alignment for tables aliases in a JOIN statement
e.g.
SELECT *
FROM dbo.table1 t1
JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
JOIN dbo.table t ON (t.c1 = tx2.c2)/*****************************
** To This
** using _ to simulate spaces
/*****************************/SELECT *
FROM
____dbo.table1 _t1
JOIN dbo.tablexyz2 tx2 ON (tx2.c1 = t1.c1)
JOIN dbo.table __t _ON (t.c1 = tx2.c2)7 votes -
Add formatting options for Window Functions
Add formatting options specific to Window Functions (e.g. ROW_NUMBER) for line breaks and spacing on the different arguments part of the function PARTITION BY, ROW, ORDER BY etc.
7 votes -
Alphabetical listing when creating a SELECT list
Allow for an alphabetical listing when creating a SELECT list? It makes it difficult to quickly check the checkboxes when quickly adding columns.
7 votes -
Force capital word
There are some identifiers and variables we'd like to force with CAPTITALS regardless of the formatting rules.
Similar to the "General > Available prefixes:", could we have a "Force word formatting" option where we can enter these special word types? ie. TranSid ==> TRANSID
6 votes -
Add an option to show/hide or find columns in the Results pane
It will be very helpful if you have an option to Show/Hide the columns in the Result Set and also an option to search the columnname.
6 votes -
where used: From a view or sp or function get a list where you have used this
Sometimes you want to find all the places where you have used a certain view/sp/function because you like to change something in that part. Now its hard to find
6 votes
- Don't see your idea?