292 results found
-
Include underscore in CamelCase interpolation
In our schema, we have the unfortunate convention (if you can call it that...) of including underscores in many table and sproc names. For instance, a report sproc might be named ReportSalesByChannel. It would be awesome if the CamelCase interpretation either completely ignored the underscores in the name while providing the suggestions (so typing rsbc would suggest the above named report), or make it so the _ is one of the interpreted characters, which would allow rsbc to again suggest the above sproc. Right now any stored procedure with an underscore cannot be quickly suggested by any abbreviation…
12 votes -
Pivot Columnar / Vertical Tables to Tradiational Row-type tables
I have looked high and low for product that will meet a need that I often have; from the number of posts that I find on the net many others have as well.
More and more, with the increase in the amount of data being collected and queried, data warehouses, BI software, using columnar tables (sometimes referred to as a vertical data structure) makes more since. Vertica DB and Terri Data use this structure natively.
However, it often is necessary to convert (or pivot) the data to a traditional horizontal, row-based format. In SQL Server as well as Oracle, and…
12 votes -
Word Wrap SELECT list only
Currently there is an option in the Code Formatter to word wrap code if it exceeds the right column margin, but that isn't ideal for the instance where you want an individual clause in the WHERE statement to stay on a single line no matter how long they are (makes it clearer what the exact logic is). Disabling this, though, forces all of the columns in the SELECT list to be on one line (I have stacking disabled for the fields). I'd say it is a common enough convention to warrant a special flag just for word-wrapping the columns in…
11 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 -
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…
11 votes -
Table alias gets converted to uppercase
When using a table alias of "u", all new instances becoming capitalized incorrectly.
Please see attached gif:
https://ibb.co/fr9LcH10 votes -
Document Sessions Improvements Phase 2
Thank you for implementing enhancements to the document sessions. It looks great and adds much more value. I would like to suggest couple more enhancements:
- It would be more convenient if more recent sessions would be on the top instead of the bottom
- Apply connection coloring to the document sessions. So each file name would have a background color of the connection. It would make the 2 features integrated and extremely useful.
- Have a setting to remove old sessions older than 2 months (or period specified by users)
- Fix Display connection details next to each file (as you do in…
9 votes -
Order by in over clause (ranking functions) should have own settings
For ranking functions, the order by clause should not be formatted the same are the order by in a select.
sample:
Select
[RowNumber] = RowNumber() Over (Order By o.[Order ID]
, o.[Sort Order]
, o.[Entry No])8 votes -
Have shared settings and snippets
We have a team of people and we'd like them to have one set of settings and snippets rather than having to keep multiple up to date.
8 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 -
When a single quote is entered, add a trailing quote. And prefix leading single-quote with a N if field is unicode. Move insertion point
When a single quote is entered, add a trailing quote and prefix the leading quote with an N if equality with a Unicode value can be inferred. Move insertion point between the quotes.
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 -
Copy as SQL values List
Would be great to be able to highlight multiple cells in the Results grid and then select "Copy as SQL values List". This would then create a single line, comma-separated list which could, for example, be pasted into a WHERE in () clause.
Functionality must be able to detect whether you're copying integer or character values etc. If copying character values, SQL Complete should automatically enclose each value with single quotes
7 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
7 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
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 -
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 -
Options group for logical operation enclosed in braces
Add an option group to the formatting profile for the logical operation enclosed in braces. This option group should include the following options:
Line break before opening brace
Line break after opening brace
Line break before closing brace
Line break after closing brace
Indent braces
Indent logical operation
Format braces around single comparison operation as in logical operationsAlso, make the same options group for the following predicates:
- EXISTS
- ALL
- ANY
- SOMEFor details, please the Devart forums http://forums.devart.com/viewtopic.php?f=33&t=35030
6 votes -
Global Refactor (rename) tables/views/procs in dependent views/procs
SQL Complete has an option to do renames within the current script. It would be great to support refactoring (rename) tables/views/procs/functions in dependent views/procs/funtions.
For instance:
CREATE TABLE dbo.Test (a INT, b INT, CONSTRAINT [PKdboTest] PRIMARY KEY (a))
GOCREATE VIEW dbo.vwTest
AS
SELECT * FROM dbo.Test
GOCREATE PROC dbo.spUpdateTest
(
@a int,
@b int
)
as
UPDATE dbo.Test
SET b = @b
WHERE a = @a
GOOn a separate screen (or from SSMS object explorer) choose refactor and change table name from "dbo.Test" to "dbo.GoodTableName" and SQL Complete would identify all objects where dbo.Test is…
6 votes
- Don't see your idea?