275 results found
-
xml Data Type methods
The xml Data Type methods (http://msdn.microsoft.com/en-us/library/ms190798.aspx) MUST be lower case. We have keywords set to be upper case, and that makes the xml Data Type methods upper case too, which does not work.
0 votes -
Options -> Settings -> Qualify column name -> **enclose with []
It would be a nice feature if you can add to database, schema and table brackets []. If you use certain characters like $ you have to enclose it with [].
28 votesIt’s implemented in the latest build of SQL Complete. Have a look at the “Enclose identifiers within square brackets” option.
-
Add 'Place open brace on new line' option for WITH clause
WITH Dates
AS (SELECT DISTINCT test
FROM test
)
SELECT *
FROM Dateswhere I am expecting it to look like this:
WITH Dates
AS (
SELECT DISTINCT test
FROM test
)
SELECT *
FROM Dates1 vote -
Shortcuts for common queries like SELECT * FROM
I saw another program that allowed shortcuts such as typing ssf generated query "SELECT * FROM"
I could create new shortcuts too. See this for details: http://www.ssmstoolspack.com/0 votes -
Function names in uppercase
While writing a function name in a query, sqlcomplete force the name to lowercase. In Turkish we have "I" letter and its lower char is "ı" not "i". I mean, when i want to write MIN() function, sqlcomplete replaces with "mın()" not "min()". If you allow function names to be uppercase it would be great. Thank you
2 votes -
Installer - Give option to ignore message about running applications
Everytime I upgrade, the installer forces me to exit Visual Studio. However, I only install SQL Complete for Management Studio. Please give me an option to ignore that error message
35 votes -
Add 'Place view definition on new line' option
Make it ignore the DDL part and just format the actual view definition
ALTER VIEW v_xyz AS
SELECT
.. some complex queryGO
1 vote -
After the 'LIKE'
To have an option to on-off and when it is on -
when the keyword 'LIKE' is typed or selected, put the 2 percentage signs sorrounded by single quotes and keep the cursor in between.
Ex:
Select * from t where FirstName Like '%%'5 votesYou can create a snippet wit the Snippets Manager filling in its fields as follows:
Shortcut: like
Description: LIKE ‘$CARET$’
Text: LIKE ‘$CARET$’
-
Highlight the BEGIN/END ?
Highlight the BEGIN/END ?
5 votes -
Declare indent
Allow option to not fancy indent declared variables, but just put a new line after declare, and have all variables just indented with a tab (normally).
1 vote -
Product Update Manager Improvements
It should offer to close SSMS, wait for the save dialog to exit and launch the update.
Or if that can't be done, it should at least launch explorer with the file highlighted after download.
6 votes -
13 votes
-
4 votes
-
Provide option to align column aliases
Currently, aliases are placed directly after the column name. Would like to be able to align them and see all aliases in the same column start position
SELECT
, FirstName + ' ' + LastName PurchasedBy
, BranchName BName
, DamageTotal Damage
, PurchasePrice - WBACValuation AdjAmount1 vote -
Place "AND" logical operator in "JOIN" clause on new line
For readability it would be great if the "AND" operator in a join clause could be on a new line. We currently have:
FROM
TABLE A
INNER JOIN TABLE B
ON B.KEY = A.KEY AND B.DATE = A.DATE AND .......... etc.Would be nice if we can have:
FROM
TABLE A
INNER JOIN TABLE B
ON B.KEY = A.KEY
AND B.DATE = A.DATE
AND ......... etc.8 votes -
Script from Result Window
Shall we give some option to generate the Insert/Update/Delete scripts from the Selected Result Window
For Eg.
SELECT * FROM Employee WITH(NOLOCK) WHERE DepartmentID = 1
Lets assume that, this query returns five recards. The User should able to see Insert/Update/Delete Scripts menu when the User right clicks in the result window.
If the User Clicks Insert, we have to generate the Insert script for the Selected Rows & Columns.
If the User Clicks Update, we have to generate the Update script for the Selected Rows & Columns with the where clause. The where clause should map with primarykey.
If…
9 votes -
Tab ident formatting without space ident at all
Allow SQL formatter to change spaces to tabs and vice versa.
2 votesThis can be setup in the ‘Text Options’ section that can be invoked by pressing down the ‘Show text options’ button on the toolbar of the ‘Edit Formatting Profile’ window.
To open the ‘Edit Formatting Profile’ window, please perform the following:
1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select the active profile and click the ‘Edit Profile…’ button. -
Support for ALTER TABLE statements
Support for ALTER TABLE statements
For example if I type in "ALTER TABLE " I don't get the list of tables in the database (as I would if I typed "UPDATE " for example). Similarly if I then type "ALTER COLUMN " I don't get prompted with column names (as I would if I typed "UPDATE MyTable SET ").
Lastly if I try and format an ALTER TABLE statement it all gets put on a single line. It would be nice to be able to format an ALTER TABLE statement on multiple lines, for example breaking before an ALTER COLUMN…
7 votes -
auto select the first suggestion
Auto select the first suggestion by default, and I don't need to click or select it, thanks.
1 voteSee comments
-
"Run Current Statement" Suggestions
I use Oracle SQL Developer more than SQL Server Management Studio, and constantly find myself attempting to use Ctrl-Enter in SSMS to execute the current statement, instead of the existing shortcut of Ctrl-Shift-E. Since Ctrl-Enter in SSMS currently appears to provide the exact same functionality as does the Enter key alone, could Ctrl-Enter perhaps be an additional (or alternate) shortcut for "Run Current Statement"? I can't think of any reasons why there would be any objection to this, but if there are, perhaps this functionality could be turned on or off via an Option.
If a SELECT statement ends with…
16 votes
- Don't see your idea?