309 results found
-
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 -
sorting the fields in a INSERT INTO statement in the same order as the SELECT statement of the query (or vice versa), taking into account t
Sorting the fields in a INSERT INTO statement in the same order as the SELECT statement of the query, taking into account the column aliases. Thus
INSERT INTO table
(columnA, columnB, columnC)SELECT foo AS columnB, columnC, bar AS columnA
FROM table2becomes
INSERT INTO table
(columnB, columnC, columnA)SELECT foo AS columnB, columnC, bar AS columnA
FROM table2With a few columns it's no big deal to do it manually but with 20 columns it is.
Displaying a hint if columns are missing is also welcome.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 -
Add IntelliSense for more linked server types
Currently SQL Complete only provides IntelliSense for linked servers with the server type of SQL Server. Please add support for other linked server types, such as Oracle, generic OLE DB, etc.
1 vote -
1 vote
-
Add an option to group database entities by schema rather than flat alphabetical.
Add an option to group database entities (tables, views, stored procedures, etc.) by schema rather than flat alphabetical. Click +/- sign to expand or collapse schemas.
1 vote -
Formatting for: Create Type <name> as table
Currently, Create Type <name> as table (
doesn't use any formatting rules.
Can we have this use the same rules as CREATE TABLE?1 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 -
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 '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 -
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 -
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 -
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 -
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 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 -
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 -
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 -
1 vote
- Don't see your idea?