282 results found
-
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 -
All keywords should formated
Sql Complete should format 'if' and 'begin' 'end' like
DECLARE @a as int
SET @a = 1
if (@a=1)
begin
print('a')
end1 voteThis functionality is already implemented in the product. If you have problems with it, please contact technical support.
-
Separate formatting for subquery
It would be very nice to have options for separate formatting for subquery, for example:
SELECT
OrderID,
OrderName,
OrderDate
FROM Orders
WHERE ClientID = (SELECT ClientID FROM Clients WHERE ClientCode = 'ABC')Here, I need the main SELECT to be stacked and formatted appropriately, and subquery SELECT - to be wrapped and in one line).
In large and complex SQL script this feature is invaluable.
Currently it is not possible - one format is applied for everything.
Thanks.
24 votes -
Option to align "ON" clauses to "JOIN" statements
SQL Complete currently formats ON clauses as follows:
SELECT
--BarcodeId,
--LastName,
--FirstName
FROM
--pplpeople
--INNER JOIN pplclient
----ON pplClient.PeopleId = pplPeople.PeopleId
WHERE
--BarcodeId = '12345'Need to be able to format ON clauses as follows:
SELECT
--BarcodeId,
--LastName,
--FirstName
FROM
--pplpeople
--INNER JOIN pplclient
--ON pplClient.PeopleId = pplPeople.PeopleId
WHERE
--BarcodeId = '12345'3 votes -
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 -
Additional condition for the 'Insert space after comma' formatting setting
Space after comma is great, but please add an option for "except when comma is first on a row" (eg. stacked lines).
9 votes -
Provide a global rename option of and alias
Have the ability to right-click or hover over an alias and be able to choose "Rename". By renaming the alias in one place it would automatically rename all other references to the alias in the query.
For example: I create a table and it get aliased as r1. I then rename it to rnk, which would change the loin reference to rnk right away.
75 votesThe feature is implemented in SQL Complete v4.7.
-
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 -
4 votes
-
27 votes
-
2 votes
- Don't see your idea?