309 results found
-
fixed length table alias
create an alias with a fixed length this will make the cut and past of a block much easier
1 vote -
Add option to make snippits keywords only look to the left of the cursor of the current word.
I often wish to trigger the "select * from" snippit by doing the following:'
1) Drag table from ObjectExplorer to a new line (or copy/paste to new line)
2) Press "Home" to get to beginning of line
3) Press "ssf" then "tab" to fire the triggerThe problem is that because the tablename is connected to the snippit, the snippit doesn't fire, and i have to then add a space, go back one spot, then hit tab.
The snippits also seem to require that all code on the rest of the page be correct. Often I have an open query…
1 vote -
Ctrl+D - for Duplicate text
Ctrl+D - for Duplicate text
1 vote -
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 -
While editing sql, add a shortcut to open an window/tooltip with the object (selected text) sql create: stored procedure, table, etc. And/or
While editing sql, add a shortcut to open an window/tooltip with the object (selected text) sql create: stored procedure, table, etc. And/or to browse to the object.
1 vote
- Don't see your idea?