272 results found
-
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 -
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 -
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 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 -
1 vote
-
Allow hiding of standard columns when expanding "SELECT *" with TAB
I would be helpful to be able to hide ID or partitioning columns that may not ever be needed when selecting data. They just get in the way when expanding SELECT * but are still necessary to the table structure.
3 votes -
3 votes
-
It would be nice to be able to format the BY after GROUP and ORDER as a different line of code
Would like to have the following:
GROUP
BY p.ProjectNo
,p.Titleand
ORDER
BY p.ProjectNo
,p.Title2 votes -
Formatting option for BACKUP/RESTORE commands
I like BACKUP/RESTORE commands formatted so that all the options (especially MOVE options) are on separate lines in order to enhance readability.
0 votes -
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 -
Add setting for color of "highlight Occurrences" or document where this is control in SMMS.
There is a choice on Options > General named Highlight Occurrences. I don't like the way this looks with my color scheme. Suggestion: allow me to change the default highlight color or document where that color comes from in SMMS's color settings.
4 votes -
Vertical Tabs for Files
In Visual Studio there is a plug that allows you to have the document tabs down the right hand side, which when you have loads of files open is very useful, especially now we have widescreen monitors. However SSMS is behind the times and the tabs along the top isn't enough. Can you please add a feature to display the sql tabs down the side rather than the top.
3 votes -
Scrollbar highlighting
When you select something in the SQL code and it selects all the other instances of it - e.g. a variable name, can you place coloured markers in the scroll bar of all the selected items, also for when you do a find as well. This is really useful feature in visual studio.
5 votes -
Add column names to VALUES list for INSERT INTO statement generation
When generating the INSERT INTO statement after typing INSERT INTO [TableName] and hitting tab, it would be helpful in the VALUES list, in addition to showing the default value, if the column name was included. For example -
INSERT INTO Users
VALUES (DEFAULT /ID/, '' /FirstName/, '' /LastName/)This way, for wide tables, you don't have to count column to keep track of which column you are working with.
2 votes -
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 -
Option to right-align table aliases in SELECT list
Add an option to right-align table aliases in the SELECT list.
Here is an example:
SELECT
-> [alias]->-> -> -> =t.col1
-> ,[differentlen] -> =t.col1
FROM tablename t=t.col1 should be right-aligned and stay under each other.
12 votes -
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 -
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 -
Smarter subquery intellisense
It would be nice to have smarter subquery intellisense that works like the joining intellisense that suggest matches based on column names.
E.g.
SELECT * FROM Users WHERE EXISTS (SELECT 1 FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID AND UserRoles.RoleID = 1)E.g.2
E.g.
SELECT UserID, UserName, (SELECT COUNT(1) FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID) AS NumberOfRoles FROM Users3 votes -
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
- Don't see your idea?