157 results found
-
Extend Insert Highlight Occurences feature to show popup with column name in the values area
when typing out the values for an insert statement
SSMS should popup an infotip very much like when inserting parameter for functions in Visual studio C# code.
e.g. After typing the , (comma). SSMS should show a popup
Insert into Person.Address
(
AddressLine1
, AddressLine2
,City
,StateProvinceID
)
Values
(
,N''
,N''
,N''
, __________________________#
StateprovinceID int not NULL #
_________________________#
^ popUP
2 votes -
SELECT Results Generate INSERTS INTO Temp Table / Table Variable
How about a feature which would take a SELECT result, declare a Temp Table / Table Variable based on the schema of the result, and generate INSERT INTO statements?
I do this often when comparing data across disparate systems where the source data is scripted into a table variable to be compared in the destination system. I use a combination of CONCATs and a WHILE loop to handle the need for a trailing comma (if using VALUE), or trailing UNION if using SELECTs as insert into source.
1 vote -
align equals
I like the option to align assignments in SELECT, UPDATE, etc, but I don't like that the alignment happens after the equals sign. It's much neater and easier to read when each column is aligned with an equals sign for the assignment.
(It's for this reason we use equals for column aliases rather than AS)
3 votes -
Go To Definition should open a connection if one is not already open
Currently you get an error if the Object Explorer is not connected to the same server. Seems like SQL Complete could make that connection for us and save that step.
1 vote -
code preview when hovering a tab or session in the "Documents Sessions" window
Code preview when hovering a tab or session in the "Documents Sessions" window. I often have several tabs open at once and they are all called "SQLQuery#.sql" which doesn't help. Allow me to see what code is in the tab by hovering it, or ctrl+tab or like tabing through windows or hovering windows in the taskbar in Windows.
3 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 -
Performance when starting visual studio
When starting visual studio with SQL Complete, it takes 15 seconds more to open Visual studio.
Maybe you can change to load the data after visual studio is opened? That way the delay is not visible to the user.
3 votes -
add a shortcut to do a "edit top 200 rows" on a selected SQL sql statement
Add a shortcut in the context menu to do a "edit top 200 rows" on a selected SQL sql statement
5 votes -
format section after press tab to complete
when typing an insert statement (as an example), I get the prompt to "Press Tab to paste full INSERT statement". After pressing tab, SQL Complete will put the insert statement in there to the formatting rules specified.
There are situations where I do that and the insert statement is tabbed over to the right but the full statement pasted is over to the left. Could SQL Complete format it so that the paste is formatted where it should be? It would save me a format document request!
1 vote -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 "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
- Don't see your idea?