270 results found
-
Goto Type/Database Object
Resharper, a popular addon for visual studio has a nifty feature where you can hit ctrl+t to open a compact search window where you can type part of a type name, and a list of clickable suggestions is presented as you type.
http://www.jetbrains.com/resharper/features/navigation_search.html#Go_to_Type
It would be quite handy to have something similar for Management Studio.
Clicking any of the matches could open a new query window with an ALTER statement prepared.133 votes -
Highlight Unused Variables
Declare @var1 INT, @var2 INT
SELECT @var1 = 1, @var2 = 2
SELECT @var1 [@var1]
-- @var2 should be highlighted in the declaration since its assigned value is never used.128 votes -
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 -
Add option to include (NOLOCK) when auto-completing
Due to the nature of our data, we use NOLOCK on most of our queries. It would be useful for us to be able to automatically have (NOLOCK) included when part of a statement is auto-completed. It may be useful to have it so that this option can be turned on only in specific databases.
63 votes -
Suggest WHERE conditions
Let's say, there are tables A and B linked with a foreign key.
Currently, dbForge SQL Complete suggests joining conditions:
SELECT *
FROM dbo.A a
JOIN dbo.B b ON ->> a.id = b.idAs part of this feature, dbForge SQL Complete could also suggest conditions in the following queries:
SELECT *
FROM dbo.A a
OUTER APPLY (
SELECT TOP 1 *
FROM dbo.B b
WHERE ->> a.id = b.id
) tSELECT
*
, (
SELECT TOP 1 ', '
FROM dbo.B b
WHERE ->> a.id = b.id
)
FROM dbo.A aSELECT *
FROM dbo.A a
WHERE NOT EXISTS(…57 votes -
54 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 -
Include Snippets in Import and Export Settings
It would be great if there was an option to import/export snippets in the "SQL Complete->Import and Export Settings".
This way snippets could easily be shared between team members.
29 votes -
"Folding" queries
It would be interesting to be able to "fold" and "unfold" a query from a single line state (still showing the full query) to a multiline, formatted state.
The following query, for example,
| |
|+| SELECT * FROM SomeTable WHERE SomeField = 3.14;
| |would unfold to
| |
|- | SELECT
| | *
| | FROM
| | SomeTable
| | WHERE
| | SomeValue = 3.14;
| |and back.
28 votes -
Execute Current Statement - Key binding
PLEASE, allow user to change the keybinding for 'Execute Current Statement' , this should not be that difficult. Believe it or not, I have to move my hands on the keyboard quite a bit to type 'Ctl-Shift-E' .
If you can't open it up for a custom key binding , then at least give some options , like ' Alt-E ' would be very nice.
Related to this feature:
http://devart.uservoice.com/forums/87893-sql-complete/suggestions/1335977-add-a-feature-to-run-current-statement25 votes -
Add vertical scroll bar to 'Quick object info' hint
Add vertical scroll bar to 'Quick object info' hint to make it possible to view the complete list of the table columns (table with more than 60 fields).
23 votes -
implement new code formatting options
SELECT
......p.PersonType,
......p.NameStyle,
......p.Title
FROM
......Person.BusinessEntity be
INNER JOIN
......Person.Person p
............ON
..................be.BusinessEntityID = p.BusinessEntityID
INNER JOIN
......Person.PersonPhone pp
............ON
..................p.BusinessEntityID = pp.BusinessEntityID
..................AND
..................be.ModifiedDate = pp.ModifiedDateWHERE
............1 = 1
......AND
............p.Suffix = 'N'
......AND
............p.Title NOT IN ('A1', 'B1','C1')
......AND
............(
..................p.FirstName LIKE '%abc%'
..................OR
..................p.LastName LIKE '%def%'
............)Add the following options to customize the code formatter regarding the example located above:
For JOIN's
one indent less than currentFor WHERE clause
stack conditions
Line break after opening brace of logical operand
Line break before closing brace of logical operand
Indent condition in list braces
Wrap condition…23 votes -
Quick/favourite Connections
A popup that list recently used/pinned servers-database
allowing for 1-click switch to that database while writing your query.
A shortcut key for this would be appreciated.The Current default SSMS behaviour > Select a server then select a database then continue working. sometimes ones default database is set to master/orsomedb which is inconveinient and always has to switch.
19 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 statements17 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 -
copy to code
After I create a query in Sql Management Studio, what I usually do is copy the sql to code. I'm programming in c# and when I copy the sql to code, I must add parentheses at the start and the end of each line with also a '+' character to tells compiler to combine line.
A very beautiful feature would be to add a shortcut to copy the sql into the clipboard but with these parentheses and '+' character. After that, I just simply have to paste it without error directly into my code.
Another very beautiful feature would be…
14 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 votes
AdminDevart
(_, Devart)
responded
dbForge works with user types.
Could you please describe it in more detail?
-
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
- Don't see your idea?