230 results found
-
1 vote
-
Format rule for CREATE TABLE
Need a format rule for CREATE TABLE.
1 vote -
Implement code formatting for Merge statements
Currently, the SQL Formatter has absolutely no options for Merge statements, and they are not formatted very nicely at all.
Please provide options for formatting all the aspects of Merge statements:
- Using section
- WHEN MATCHED section
- WHEN NOT MATCHED sections
- Output sections
Also, if possible, provide the option to have these sections use the same formatting as standard statements. E.g. Update statement in When Matched section uses standard update format, etc.
6 votesThis feature is implemented in dbForge SQL Complete, v4.8 http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
ability to create some snniped
ability to create some snniped
1 voteThe Code Snippets feature is available in the fully featured 30-day Trial version of the Standard Edition of dbForge SQL Complete http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Intellisense for table definition should use INFORMATION_SCHEMA data.
It seems the current implementation parses a CREATE TABLE statement and only shows the columns defined there when you hover over a table name. Columns added later via ALTER TABLE statements do not show up. The intellisense list should be built by querying the CURRENT table structure via INFORMATION_SCHEMA.COLUMNS in order to show all columns.
3 votesPlease check that you have selected the ‘Automatically refresh suggestions cache’ and ‘Detect changes on a server before refreshing suggestions cache’ options in the ‘Text Editor → Code Completion → General’ section of the ‘Options’ dialog box that can be opened by selecting ‘Tools → Options’ from the main menu.
Please also check that the altered object belongs to the database selected in the ‘Database’ drop-down menu on the ‘SQL’ toolbar.
-
Format first row in stacked list with leading space
You should be able to add a leading space for the first row in a stacked list with leading commas, so the column names would be evenly aligned.
8 votesThis feature is implemented in version 4.8 and applies when the ‘Stacked List → Place comma before item in stacked list’ and ‘SELECT → Select List → Line break before first column’ options are selected in the ‘Edit Formatting Profile’ dialog.
-
3 votes
-
Geography / Geometry Suggestions
Add support equivalent to the XML suggestion capabilities, but for the Geography and Geometry data types.
5 votes -
Ability to change the keyboard shortcuts used in SQL Complete
Add the ability to modify the keyboard shortcuts used for certain SQL Complete features. Reason for requesting this is due to the fact that certain keyboard shortcuts chosen by SQL Complete may clash with shortcuts used by other third party tools.
In my case, the format selection shortcut, Ctrl+K, Ctrl+F is used in the SSMS Tools Pack add-in I have installed. So when I try to use Ctrl+K, Ctrl+F I get the SSMS Tools Pack resultant of the shortcut, and not the format selection option of SQL Complete.
3 votesThis is available in VS/SSMS 2012 or higher.
-
Indent table after FROM
Treat FROM and JOIN as equals be able to indent table names ex:
FROMTableA
JOIN
TableB6 votes -
CrLf after last GO
I'm always adding to batches and no blank line at EOF frustrates the heck out of me.
4 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 -
format selection by a profile I select
I'd like to select some code, right click, and have menu choices to match my profiles such as:
Format Selection Horizontal (tight)
Format Selection Vertical (spacious)6 votes -
Refactoring: Change variable name in procedure
refactoring (change a variable name in a procedure for example, and have that change propagate throughout the procedure for each instance of the variable)
3 votesThe feature is available in SQL Complete v5.0!
-
Oracle style formatting for SQL statements
It would be great if we could have the Oracle style SQL formatting option, where keywords are right justified and the arguments are left justified. Like below:
select col1, col2, col3
from dbo.tableName
where col2 = 1233 votes -
3 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 -
Support INSERT/UPDATE statements within MERGE statement
Provide the column list for the INSERT/UPDATEs within the MERGE statement.
18 votesThis feature is implemented in dbForge SQL Complete, v4.8 http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
If the word I manually type matches an autocomplete entry, apply the case in the AutoComplete to the typed word.
If the word I manually type matches an AutoComplete entry, apply the case in the AutoComplete to the typed word. This would apply to both reserved words and object names.
Example 1: I type 'sel' and wait a millisecond. 'SELECT' appears in the AutoComplete. I press [space] and SELECT is typed for me. Next, I type 'select' and press [space] without waiting. The word remains lower case.
Example 2:I type 'select * from peo' and wait a millisecond. 'People' (a table name) appears in the AutoComplete. I press [space] and 'People' is typed for me. Next, I type I type…
1 vote -
Ability to expand columns when typing UPDATE statements (similar to INSERT)
- Let's assume we have a table:
CREATE TABLE dbo.Employee
(
EmployeeID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
IsMainWorkPlace BIT NOT NULL,
TabelNumber VARCHAR(6) NULL,
PersonID INT NOT NULL,
DepartmentUID UNIQUEIDENTIFIER NOT NULL,
DateIn DATETIME NOT NULL,
DateOut DATETIME NULL,
IsLabourUnionMember BIT NOT NULL,
FiringReasonID INT NULL
)- Let's type the following construction and click TAB at the end:
UPDATE dbo.Employee
- Suggest to expand columns just like it's implemented for INSERT:
UPDATE dbo.Employee
SET
IsMainWorkPlace = DEFAULT /* IsMainWorkPlace - BIT NOT NULL /
, TabelNumber = '' / TabelNumber - VARCHAR(6) /
, PersonID = 0 / PersonID - INT…46 votesMeet the feature in SQL Complete v5.0!
- Don't see your idea?