313 results found
-
disable / autoexclude colums [v].IDENTITYCOL, [v].$IDENTITY from select
Exclude columns [v].IDENTITYCOL, [v].$IDENTITY from select when checking the table checkbox on the suggestion popup window
example:
SELECT [v].id, [v].name, [v].IDENTITYCOL, [v].$IDENTITY FROM table [v]3 votes -
add a "edit data from query"
Add a "edit data from query", on the left click, in the query editor, to open the same module as when "Edit top 200 rows" in the table list is selected.
1 vote -
format json output
Add an option to format JSON output with proper indentation and line feeds
2 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 -
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 -
Format: line break before From, Where, group by & Order by
You already allow a line break before FROM.
Allows me to specify the number of line breaks.
in my case i wish to use 2 line breaks after the select list
i.e.SELECT
Column1
, Column2
, Column3FROM
SampleTable AS STWHERE
ST.Column1 > 11 vote -
separate options for text case for tables and columns
I like to have separate options for setting the text case for table aliases and for column aliases.
Personally I want my table aliases to be in lower case and my column aliases not changed (or starting with initial caps, depending on the project I'm working on).1 vote -
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 -
Simplify snippet editing with variables
SQL Prompt allows quick editing of snippets by typing a variable name wrapped in dollar signs and automatically adds this to the bottom list of variables to edit. This makes editing a snippet very easy, and doesn't require as many steps as the current SQL complete UI for adding custom variables. Consider evaluating using this type of simplified editing experience.
1 vote -
Snippet - Wrap selected text in snippet
SQL Prompt has a fantastic feature that allows selected text to be wrapped up by pressing control + selecting snippet that utilizes the SELECTEDTEXT value. This is great for wrapping up text in "Begin try", "comment blocks" and other selection oriented snippets.
2 votes -
Filter autocomplete list by any substring, not just word initials
Today, SQL Complete supports filtering the AutoComplete list by typing the initials of CamelCase identifiers. In Resharper, you can type any sequence of characters from the member you are looking for, and the autocomplete list is filtered by any members which contain the character you typed, as long as they appear in the same order you typed. This makes it easier to find what you are looking for, because it's easier to type parts of words than to remember the exact words and their initials.
3 votes -
Add "Copy Current Statement (Ctrl+Shift+C)" & "Cut Current Statement (Ctrl+Shift+X)"
Execute Current Statement is a great feature to test out a statement currently being worked. Sometimes I like to break a statement out to its own query window for further development.
Copy (or Cut) Current Statement would work just like Execute Current Statement except it would copy (or cut) the statement to clipboard instead of executing it.3 votes -
When Formatting, Place Short Queries on a Single Line
I would like the option to specify that queries under a certain number of characters be formatted to be on a single line. This would also apply to subqueries so that if they are over the specified limit it follows the formatting rules already in place for subqueries but places simple subqueries on a single line.
So
SELECT
*
FROM
TABLE
WHERE
COL1 = 5;would become
SELECT * FROM TABLE WHERE COL1 = 5;
and
SELECT
COL1,
COL2,
COL3,
COL4,
CASE WHEN COL5 = 50 THEN 'A' ELSE 'B' END
FROM
TABLE
WHERE
COL1 IN (
SELECT
COLB
FROM…2 votes -
Add option to adjust font on intellisense
No option to enlarge font. font size on intellisense is too small.
3 votes -
Do _NOT_ hijack Ctrl+S. It is not your key combo to mess with.
Ctrl+S is not to be hijacked in the default install under any circumstances.
2 votes
AdminDevart
(_, Devart)
responded
Could you please let us know after what actions exactly it started happening and what exactly happens when you press the mentioned key combination?
Please also specify what versions and editions of dbForge SQL Complete, SSMS or VS you are using.
-
Allow formating on ctl-K, ctl-F to be disabled.
I have another tool I'd prefer to use for formatting, but SQL Complete captures the "ctl-k, ctl-f" clicks, preventing me from using the other tool.
1 voteAdminDevart
(_, Devart)
responded
Could you please let us know what version of SSMS or VS you are using?
Please note that in some versions Visual Studio or SSMS you can redefine shortcuts for the commands of dbForge SQL Complete (the command contain ‘SQLComplete’) in the ‘Environment → Keyboard’ section of the ‘Options’ window that can be invoked by selecting ‘Tools → Options’ from the main menu.
Also, please let us know what tool you prefer for formatting and why you chose it over dbForge SQL Complete.
You can reply straight to our support system at supportATdevartDOTcom
-
Add 'BEGIN TRAN' and 'ROLLBACK TRAN' to the suggestions list
The suggestions list already has 'BEGIN' and 'ROLLBACK' but does not have 'BEGIN TRAN' and 'ROLLBACK TRAN'. I use these a lot and it would be great if they were added.
1 vote -
Support dynamic formatting using @SQLComplete tag to override a setting
There may be times when you would like to switch the formatting for a particular section of code because the global settings would not be most appropriate.
For example let's stay in SELECT statements you have "Stack Columns" checked with "Simple List" selected. This may be the desired format for 90% of the cases, however when there is a table with a large number of columns(50+), it could be more beneficial to view them on a single line so to see the query as a whole.
If you could add a comment before the query
--@Begin-SQLComplete Select-SelectList-StackColumns = True; Select-SelectList-StackColumns-Option=SingleLine…4 votes -
Should have provision to configure Query Alignment
Should have provision to configure Query Format
like (Each column to be placed in separate Line,
Join condition in single Line,
etc.)
or
Indenting is missing in formating1 vote -
add missing column alias to the select portion of insert statements
Those that came before me had a habit of not adding these and it becomes a pain point when debugging.
--ex of how it looks like now
INSERT INTO desttable
(
id
,name
,phone
)
SELECT
code AS id
,user
,tel
FROM origintable--what I would like the addon to do
INSERT INTO desttable
(
id
,name
,phone
)
SELECT
code AS id
,user AS name
,tel AS phone
FROM origintable1 vote
- Don't see your idea?