310 results found
-
Ability to define default values for stored procedure parameters expanded by pressing Tab
When you type out "execute SPROCname" and then press Tab, SQL Complete very nicely builds out the list of parameters with commented out datatypes. Really like that. The one thing that would take this from being good to great would be if it filled in any default values from the procedure. Now that would be fantastic!
5 votes -
Option to add parenthesis into ON clause
Current formatting:
ON e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid
Expected:
ON (e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid)
3 votes -
indent logical operator
In a WHERE clause, there is an option to wrap before a logical operator, but then the operator is aligned with the WHERE keyword. I'd like an option to indent logical operators in the WHERE clause, so it's clear that they are under it.
0 votes -
Add option to align columns in WHERE clause
I'd like to align the columns in the where clause like this:
WHERE
---------------a.AddressLine1 IS NOT NULL
--------AND a.AddressLine2 IS NOT NULLI'd like the two "a." to align.
1 vote -
Add stack option for wrap condition in FROM and JOIN clauses
I'd really like the ability to have a stack option for the wrap condition in the FROM > JOIN options. What I mean is, I want to align conditions by the column name like this:
JOIN Person.Address AS a
ON e.ModifiedDate = a.ModifiedDate
AND e.rowguid = a.rowguidI'd like the two "e." to align. Simply inserting a tab after ON and after AND will achieve this.
1 vote -
Enumerate available event package names and event names in CREATE EVENT SESSION ADD EVENT
Intellisense doesn't enumerate available event package names and event names in CREATE EVENT SESSION ADD EVENT ... clause.
0 votes -
Wrap string concatenation
Have the option to set max length for concatenation string. I've seen this implemented in SQL Beautifier and it helped legibility on long strings.
User should be able to choose max length of characters before wrapping begins, then wrapping begins with + at beginning of line.
It changes string from long string that user must scroll or have word wrap affect.
BEFORE:
,comment_string = 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text' + 'Sample text'to:
,comment_string = 'Sample text' + 'Sample text'
+ 'Sample text' + 'Sample text'
+ 'Sample text'This would be great to…
0 votes -
Text editor improvement: Text column select enhancements
When I am in Visual Studio and I hold down Alt and select a range of text, I can start typing and it will type into all rows. I use this frequently to type something that needs to be typed across several lines. In SQL Server Management Studio, the highlight process works, but as soon as you start typing, it only types in the first row that is selected.
I would really like to see the input behavior from Visual Studio mimicked in SSMS.
1 vote -
Row_number() formatting issue
Formatting for rownumber() seems to have issues with breaking up the line. I don't know if the parser is evaluating it as a possible subquery, but it would be great to have the option for a single line or wrapped line rownumber(). A row_number() statement on 4-5 lines seems to be a little confusing.
3 votesAdminDevart (_, Devart) respondedCould you please provide us a concrete example demonstrating this and describe it in more detail?
-
Option for Line break between tables in join
Multiple tables in the join statement are indented correctly, but no option to add a line break between the table joins. I find this line break to help legibility when dealing with many tables in a join.
I think adding the option "break before JOIN keyword" would solve that issue, and not require evaluating for subquery or further complex on statement conditions.
0 votes -
Ability to insert frequently used templates without need to modify them
Let's assume, a user have about 10 most frequently used templates that do not need to be modified after they have been inserted unlike snippets.
0 votes -
When pressing "Enter" at the end of a line, the indentation of the next line should be same as the previous line
For example:
IF @ID > 1
BEGIN
SELECT '1'
FROM ID
ENDInstead of
IF @ID > 1
BEGIN
SELECT '1'
FROM ID
END1 vote -
Support formatting of ORDER BY clause within OVER clause
currently if I format the following code
select
row_number() over (order by cl.f1
-------, cl.f2
-------)
- 1 as f2
,cl.f3
,cl.f4
from #clients clI get this output
select row_number() over (order by cl.f1
-------, cl.f2
-------)
------ - 1 as f2
,cl.f3
,cl.f4
from #clients clbut the desired output is
select row_number() over (order by cl.f1
---------------------------------------------,cl.f2
---------------------------------)
------ - 1 as f2
-------,cl.f3
-------,cl.f4
from #clients cl5 votes -
Include Snippets in Import and Export Settings
It would be great if there was an option to import/export snippets in the "SQL Complete->Import and Export Settings".
This way snippets could easily be shared between team members.
29 votes -
Paragraph between SELECT FROM WHERE etc.
Option to have a paragraph, not just a break, between elements of the statements:
SELECT field1
FROM table
WHERE field1 IS NOT NULL;
3 votes -
Create a variable table based on a available table in the schema
DECLARE @table varchar(100)
SET @table = 'claims'DECLARE @noScale varchar(255)
SET @noScale = 'INT,TINYINT,BIGINT,MONEY,SMALLMONEY'
SET @noScale=@noScale+',BIT,SMALLDATETIME,DATETIME' --Need for SQL2000
SELECT colName = ',' +
CASE
WHEN C.CHARACTERMAXIMUMLENGTH IS NOT NULL
THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE) + '(' + CAST(C.CHARACTERMAXIMUMLENGTH AS varchar(10)) + ')'
WHEN C.NUMERICSCALE IS NULL
THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE)
WHEN C.CHARACTERMAXIMUMLENGTH IS NULL AND CHARINDEX(C.DATATYPE, @noScale) > 0
THEN C.COLUMNNAME + ' ' + UPPER(C.DATATYPE)
WHEN C.NUMERICPRECISION > 0 AND CHARINDEX(C.DATATYPE, @noScale) = 0
THEN C.COLUMNNAME…4 votes -
1 vote
-
Extended Outline - Highlight outline which is marked by cursor
Click in Document Outline window on some outline shows code line in sql file. But it would be nice to highlight encapsulated outline after clicking in sql code file on some code line. Therefore the position in navigation tree will be clear everytime.
3 votes -
Format selected text using several styles
I need fast way to format selected text using several formatting styles, specified previously.
The formatting style specified manually into hotkey (for example, Ctrl+K, Ctrl+F, Ctrl+1 - first style, Ctrl+K, Ctrl+F, Ctrl+2 - second style and etc.).If I see a very long value clause:
INSERT INTO dbo.Table
VALUES ('111111','222222','333333','444444','555555')
I select the code and apply another style like this:
INSERT INTO dbo.Table
VALUES (
'111111',
'222222',
'333333',
'444444',
'555555'
)The hotkey Ctrl+K, Ctrl+F, Ctrl+1 is very hard to push, it is for example.
Maybe you will think of a more simple alternative, but of course without mouse usage.2 votes -
Put variables in VALUES clause when expanding INSERT statement
You type in an insert statement. " Insert into dbo.Party" and then press tab. The below code is generated
INSERT INTO Party
(
PartyTypeId,
TenantId
)
VALUES
(
0 /* PartyTypeId - INT NOT NULL /,
0 / TenantId - BIGINT */
)Because most of the inserts, updates etc are mostly used inside stored procedures, and the values come from variables, I would like it to show :
INSERT INTO Party
(
PartyTypeId,
TenantId
)
VALUES
(
@PartyId /* INT NOT NULL /,
@TenantId / BIGINT */
)An updated statement will do the following snippet :
UPDATE Party…
5 votes
- Don't see your idea?