268 results found
-
Email Query (not results)
How about adding the ability to send the contents of the query window out in an email? It's a feature I've never seen in an add-in, but it's one that I'd use almost daily. Even better would be the ability to attach the query or just have the query as the email.
1 vote -
Reconstituting function parameters on the same line
SQL Complete seems not to be able to keep function parameters "together" on the same line. For example, if a function is broken across several lines like this:
SELECT
SUM (c1,
c2)
FROM t;SQL Complete will not reformat to something like:
SELECT
SUM (c1, c2)
FROM t;In general, function parameters seem not to be understood by SQL Complete. For example, it always considers AS as its own independent entity, despite it sometimes being in a function call such as:
SELECT
CAST (c1
AS INTEGER)
FROM t;gets incorrectly formatted as:
SELECT
CAST (c1 AS
INTEGER)
FROM t;instead…
1 vote -
Control of arithmetic operators
Along the lines of keeping function parameters on a single line, SQL Complete also needs to have some control over the treatment of arithmetic operators. For example:
SELECT
c1 + c2
/ c3 as Calculation
FROM t;most formatting packages will format by default as:
SELECT
c1 + c2 / c3 as Calculation
FROM t;Some of the more advanced packages will be able to specify what to do before/after each operator (usually whether to add a newline) but at the very least SQL Complete needs to be able to "gather" a calculation onto a single line.
1 vote -
Don't generate alias if an alias is already present.
For example if i wrote a query like this SQL Complete will generate alias "ch":
select * from crm.contacts_h chbut when I change table to contacts_d then I get additional "cd" alias generated, like this:
select * from crm.contacts_d cd ch
--
Regards1 vote -
Word wrap column specification when longer than right margin, or when logical operators (NOT, AND, OR) are encountered
A column specification in a SELECT list can become very long, especially when a CASE statement is replaced by the new Iif function. The column specification will not wrap, even when its length is far beyond the right margin. E.g:
SELECT
Bom.BillOfMaterialsID,
Bom.ProductAssemblyID,
Bom.ComponentID,
CONVERT(bit, IIF((Bom.BillOfMaterialsID = Bom.ProductAssemblyID OR Bom.BillOfMaterialsID IS NULL AND Bom.ProductAssemblyID IS NULL) AND (Bom.ComponentID = Bom.ProductAssemblyID OR Bom.ComponentID IS NULL), 1, 0)) AS [Check]
FROM AdventureWorks2012.Production.BillOfMaterials AS BomThe last column specification will always end up on a single line.
1 vote -
Goto Definition (tabel) include field comments
When displaying Goto Definition of a table it would be nice to include the field comments.
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 -
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 -
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 -
Automatically replace AS alias with "=" assignment operator (or vice versa) based on formatting preference
It would be amazing to have the option to choose preference to have any column alias using "AS" flipped to assignment operator format with formatting preferences set.
This has greatly enhanced my readability of complex procs and subqueries, especially as it aligns all the select values. Please consider this as an option. Having the option to flip back to AS would be nice, but my personal request is just to be able to flip AS to = assignment operations.
Thanks!
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 -
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 -
Display column level extended properties if available in another column on intellisense popup
I see table description extended properties displaying, but no details on the column description. I'd like this to be an option, so if a business uses this for documentation, you could easily look at the column definitions while using the intellisense suggestion list.
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 -
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 -
insert into table set param
when type insert into table then type Tab can get result like bellow
Declare @SerNo XXX(SerNo RealType)
Declare @NameXXX(NameRealType)
Declare @ValueXXX(ValueRealType)
insert into TestTable (SerNo,Name,Value)values(@SerNo,@Name,Value)it's real help for me
1 vote -
Fast way to open objects (stored procedure) sql create definition
Shortcut (Shift+Alt+O) to open an window with the names of all database objects (stored procedures, tables) and a textbox to enter the name (partial, multipart) of the object to find. While typing remove non matched names from the list. When selecting an object open a menu with options like Script Object AS (CREATE, INSERT etc).
Then open a new SQL Server Management Studio window with the selected SQL code.1 vote -
Filter on the toolbar for filtering on all objects. To work in real time as you type. Current filter process is painful
Filter on the toolbar for filtering on all objects. To work in real time as you type. Current filter process is painful.
Imagine I want to filter SP's, tables, views based on the string 'pack', for stuff like 'vwpackingtray' and 'sppackStrut'. At the moment I have to go to each object type area individually, open a poorly designed dialog, select focus before typing (?), type in the search term and save.
I want a filter textbox in the toolbar, and as I type in it, the objects across the whole database(s) start to filter down to…
1 vote -
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 -
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
- Don't see your idea?