272 results found
-
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 -
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 -
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 -
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 -
Format wrapped SET Statements with indentation
When a SET statement is a series of concatenated strings and you wrap the elements, the formatter aligns the wrapped strings with the SET keyword. They should have an option to be indented. Note below that periods denote indentation.:
SET @Foo = @Bar + " some text " + @Baz +
......." some more text";Is formatted as:
SET @Foo = @Bar + " some text " + @Baz +
" some more text";Note that the indentation on the wrapped line is removed. It would be nice to have an option that results in:
SET @Foo = @Bar +…
1 vote -
Add new Forrmatter settings
Issue: Formatter, add the ability to configure segment FROM represented JOIN in tabular form.
Example: http://www.sql.ru/forum/actualutils.aspx?action=gotomsg&tid=976629&msg=162244751 vote -
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 -
Display a single row of data in column format
As per Oracle SQL Developer ability to select a row of data and have it displayed in a column. Makes viewing a large row of data a lot easier.
1 vote -
Go to definition - Add compatibility for filters
The feature to go to the definition of an object in the object explorer currently does not support filters. If that subsection is filtered where the object should be, it will give an error instead of removing/changing the filter and locating it.
1 vote -
Cache suggestions between executions of SQL Server Management Studio
Most of the time, the schema does not change when I connect to the server via SSMS. It would be nice if the auto suggestion cache would maintain itself between executions of SSMS, and only update the parts which are different from the last time. This would make the startup experience faster over slower links (like VPN) to the server. It also would help with databases that have a large number of objects.
1 vote -
Format declare statement with assignment from select statement eg DECLARE @sourceTrackId int = (SELECT Id FROM Track t WHERE t.TrackCod
Declare with select assignment does not format very well.
DECLARE @sourceTrackId int = (SELECT
Id
FROM Track t
WHERE t.TrackCode = @sourceTrackCode)1 vote
AdminDevart
(_, Devart)
responded
Could you please send us the screenshots of the actual and expected results to our support system at supportATdevartDOTcom for investigation?
-
Configure Order Code Completion by schema
Order code completion by schema. Currently it orders alphabetical by table name.
Lets say you have the following schema.tables :
main.fullfillmentaddress
staging.contactaddress
history.directrelatedaddressIf I type in the following
select * from address
(the code completion will suggest in this order):
staging.contactaddress
history.directrelatedaddress
main.fullfillmentaddressI'd prefer main to always be the first schema returned. Not a big deal when you only have a few tables but we have hundreds.
1 vote -
customisable shortcuts to insert autotext
I find myself typing the same text alot. it would be useful to be able to hit a keyboard shortcut and insert something like 'WITH(NOLOCK)'. The intellisense helps, but this could perhaps speed it up even more.
1 vote -
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 -
Improvement to Execute Current Statement.
On Toad, if a query has parameters and you run it, it prompts (dialog pops up) for values for the variables and remembers them for the next execution, so you will do the key combination for Execute Current Statement and the first time enter the values, the next time the prompt dilog comes up, just hit enter.
Select a from tbl where a = @Value
1 vote -
Improvement to Execute Current Statement.
I would like to be able to control what the Current Statement is by adding empty lines. In the example below, the inner query cannot be executed by itself.
Select a from
(select 1 as a <-- Cursor Here
)
) b
1 vote
- Don't see your idea?