275 results found
-
Autocomplete functions with braces
When autocompleting a parameter less function like say: getdate, include also the braces () and put the caret after the closing brace so you can continue typing without having to type the braces youself
When autocompleting a function with parameters, also automatically put the braces, but place the caret in between the braces (<caret here>) so you can directly start typing the parameter.
16 votes -
Auto-complete for Linked SQL Servers
We have a SQL environment that includes several linked servers and sometimes writing a quick investigative query to one of them is more conveniently done from the current context, rather than opening a new connection in SSMS. Some of my coworkers use Redgate's SQL Prompt which offers auto-completion for linked servers and I would like to see that functionality available in SQL Complete
15 votes -
15 votes
This feature is implemented in version 5.0 of dbForge SQL Complete https://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
To differentiate the 'Keyword case' formatting setting
To differentiate the 'Keyword case' formatting setting for keyword commands like SELECT, FROM, LIKE and WHERE and data types like int, varchar and money.
15 votes -
Table name after JOIN on a new line
Option to place table name after JOIN on a new line
...
FROM
TABLEA
INNER JOIN
TABLEB
ON .......14 votes -
Intellisence in SQLCMD mode
On our severs we have large number of databases with same structure and use SQLCMD variables for databaseand shema name in our scripts. Example select t1.* from $(databasename).$(shemaname).TABLE1 t1. It would be very usefull to have intellisence enabled if I type "t1."
14 votes -
Add a feature to "Run current statement"
The keyboard shortcut to run Execute statement in query editor is F5. If we have multiple queries in the same query editor window, all the query will be executed, unless we first highlight the part of query that we want to execute, and then pressing F5.
I'm suggesting that instead of selecting the statement (usually by using a mouse movement) and pressing F5, we can just put the cursor anywhere in the statement that we want to run, and then pressing keyboard shortcut (something like ctrl+F5) will run the "current statement" which is the text between the first "newline +…
14 votesVersion 3.0 is on the site
-
List all columns of a table when typing an insert statement
When you type "insert into mytable(", the autocomplete list should contain for example a star character on top, which adds all columns of the given table. So there's no need to select every column separately.
It would also make sense in select statements, when the alias is known.
13 votesIncluded into SQL Complete v2.50
-
13 votes
-
Display more information about Document Sessions
Display more information about Document Sessions. Currently, it just has SSMS version and number of files in the session (SSMS 2017 (2)).
Session Caption:
1. SSMS Version is close to useless. Because SSMS 2017 provide great backward compatibility with other SQL Server versions. So you don't really need. Please remove it.
2. Add date and time when the session was saved last time.File list:
3. It would be useful to have server and database next file name.
4. Each file has backup time but not backup date. Please add it.Document Sessions screen:
5. Revisit design of the Document…12 votes -
Table alias gets converted to uppercase
When using a table alias of "u", all new instances becoming capitalized incorrectly.
Please see attached gif:
https://ibb.co/fr9LcH12 votes -
Extend Highlight Occurences feature to INSERT SELECT construction
You have a very convenient feature Highlight Occurences to highlight all field or variable occurrences.
I would suggest you to make a highlighting of the corresponding value in the INSERT SELECT construction when navigating to a field.
In the following example, when navigating to the 3rd column, the corresponding value should be highlighted in the SELECT clause too:
INSERT INTO table (clm1, clm2, clm3, clm4, clm5)
SELECT 0, 1, 5, 0, 311 votes -
Search the grid results pane
SSMS Tools Pack has a feature where you can right click on the results pane and click 'Search Grid Results'. Then you can enter some text and it'll find data in the results that match your search term. This is VERY handy.
11 votes -
Include Schema
Can database schema be included (optionally) in the intellisense object name selection? e.g. [dbo].[tablename] ?
(the square brackets also being optional)11 votesVersion 3.0 is on the site
-
11 votes
-
11 votes
Included into SQL Complete v2.50
-
Intellisense & Format is not working in Stored Procedures
Intellisense & Formating is not working in Stored Procedures
11 votesSQL Complete v2.0 is on site!
-
11 votes
Version 3.0 is on the site
-
10 votes
-
Copy as SQL values List
Would be great to be able to highlight multiple cells in the Results grid and then select "Copy as SQL values List". This would then create a single line, comma-separated list which could, for example, be pasted into a WHERE in () clause.
Functionality must be able to detect whether you're copying integer or character values etc. If copying character values, SQL Complete should automatically enclose each value with single quotes
10 votes
- Don't see your idea?