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 -
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 -
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 -
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 -
3 votes
-
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 -
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 -
DO NOT SHOW intellisense popup after "," typed and SHOW after ENTER pressed
Guys,
The main idea is following:
When people enumerate column names between SELECT...FROM most of them can be separated on two behavioral groups:
1) People who enumerates columns on a single line
2) People who enumerates columns on a new line each.
Both of these goups after previous, already typed, column name and before typing next type "," (comma) first and then " " (space - first group of people) or ENTER (second group).
No one type next column name immidiately after comma.
So really intellisense popup needed after SPACE or ENTER but not after COMMA.
Please. disable displaying of…
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 -
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 -
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 -
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 -
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 -
unwrap
I love the "format document" and "format selection" features and would be interested in a "unwrap document" and "unwrap selection" feature.
I use Notepad++ to do it currently but it is required when trying to paste SQL Code in Visual Studio.
All it does is turn the code into 1 line...
Thanks
Yann2 votes -
3 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 -
Format Comments
I would like to format the comments that appear at the end of a line as part of the "stack columns" and "Table View".
The stacking and table view for comments should have similar behavior as the column and alias view. They appear column aligned.
Example (because posting destroys the formatting of my post, I'll use "." for spacing):
SELECT
.....column1.....AS a.........-- CommentA
.....col2............AS b........ -- CommentB
.....col3........... AS abc.....-- CommentCThank you. Jake.
3 votes -
insert into table set param
when type insert into table then type Tab can get result like bellow
Declare @SerNo XXX(SerNo RealType)
Declare @NameXXX(NameRealType)
Declare @ValueXXX(ValueRealType)
insert into TestTable (SerNo,Name,Value)values(@SerNo,@Name,Value)it's real help for me
1 vote -
Override capitalisation of certain keywords
I like to capitalise 'begin' and 'end' in lower case so my code looks like this:
IF @Return = 1
begin
SELECT Name FROM Table
end
ELSE
begin
SELECT 0
endThe begin and end words should not be as bold as the sql statements, a bit like curly brackets are.
3 votes -
Creating relation mappings for databases that may not be changed
In our company we are working with SAP Business One (SBO). SBO has a fixed database stucture which may not be changed at all. Relations are not directly built into the database.
A custom relation mapping feature would help us with correct suggestions for the databases while still maintaining the database structure as it is.
3 votes
- Don't see your idea?