280 results found
-
Copy to Clipboard from Execution History
Currently, you can only open query from Execution History as new query window. It would be useful to have the ability just copy the full or part of the query to the clipboard.
Thank you in advance.
7 votesPlease right-click the query in the ‘Execution History’ window and select ‘to Clipboard’ from the popup menu.
-
Formatting for Synapse
I have started using Serverless SQL Pool within SSMS. I have seen and voted for a post for Intellisense, but it would be good to be able to format a query too. For example the below query:
SELECT cast(r.filepath(1) as varchar(100)) as [$FileName], ISNULL(SysRowId,0) AS _SysRowId, ISNULL(LSN,'') AS LSN, ISNULL(LastProcessedChangeDateTime,'1900-01-01') AS LastProcessedChangeDateTime, ISNULL(DataLakeModifiedDateTime,'1900-01-01') AS DataLakeModifiedDateTime, ISNULL(RECID,0) AS RECID, Language, Status, Stage, ISNULL(DataAreaId,'') AS DataAreaId, ISNULL(PARTITION,0) AS PARTITION, ISNULL(RECVERSION,0) AS RECVERSION
FROM OPENROWSET(BULK 'Tables/StgTable/*.csv'
,FORMAT = 'CSV', PARSERVERSION = '2.0', DATASOURCE ='wsds', ROWSETOPTIONS = '{"READOPTIONS":["ALLOWINCONSISTENTREADS"] }'
)
WITH (SysRowId…7 votes -
Quickinfo for Objects
It would be great to have a quick information about the object(structure). For example if you type select * from [mytable], then move with the mouse over [mytable], a small window should appear with all columns + datatypes, default values etc.
6 votesIncluded into SQL Complete v2.50
-
Option not to add space after function name before parenthesis
Original:
select sum(abs(i)) from dummy
After formating:
SELECT sum (abs (i)) FROM dummy
Optimal:
SELECT sum(abs(i)) FROM dummy6 votesIncluded into SQL Complete v2.50
-
6 votes
-
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 -
Alias comprise of the first two letters of table name
Would it be possible to add an option allowing for the alias to comprise of the first two letters of the table name rather than the first, for example:
dbo.position po
dbo.product pr6 votes -
Put ON at top of suggestion list when using JOIN
When typing inner join table1, make the ON keyword display at the top of the suggestion list
6 votes -
Respect case of declared variables
I have text case for variables set to "do not change", because none of the other options match my rules exactly (e.g. I want "RecordID" not "RecordId").
The problem is that if I declare a variable (or it is an input param to a stored proc), subsequent formatting doesn't respect the casing of the variable as it was declared.
For example:
DECLARE @RecordID int
SET @recordid = 5
Ctrl-K, Ctrl-D should change it to
SET @RecordID = 5
but it does not
6 votes -
6 votes
-
Show column sizes in addition to type when hovering cursor over column names
When hovering cursor over column names, it would be nice to show column data types including sizes.
Currently SQLComplete just shows "myalias.columnName(Column)" when hovering, but it would be good to show "columnName (Type, Size)"6 votes -
Case statement in select clause - using table view
Select
c.FirstName
,ln = c.LastName
,e.JobTitle
,d =
Case
When a.AddressLine1 = 1 Then 1
End
,a.City As ct
,a.PostalCode6 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 -
Indent table after FROM
Treat FROM and JOIN as equals be able to indent table names ex:
FROMTableA
JOIN
TableB6 votes -
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
-
mark opening or closing brackets when another is selected
sql complete doesn't mark openning brackets when closing is selected etc. it's working in SSMS but, when i install sql complete it doesnt'.
6 votes -
Options group for logical operation enclosed in braces
Add an option group to the formatting profile for the logical operation enclosed in braces. This option group should include the following options:
Line break before opening brace
Line break after opening brace
Line break before closing brace
Line break after closing brace
Indent braces
Indent logical operation
Format braces around single comparison operation as in logical operationsAlso, make the same options group for the following predicates:
- EXISTS
- ALL
- ANY
- SOMEFor details, please the Devart forums http://forums.devart.com/viewtopic.php?f=33&t=35030
6 votes -
Suggest JOIN expressions and conditions
1 In SELECT statement after user types JOIN suggest full clause basing on table foreign keys.
2. When user types JOIN condition after ON suggest conditions table basing on table foreign keys and matched column names.5 votes -
List members for CTEs
List members for common table expressions
5 votesIncluded into SQL Complete v2.50
-
Different (or customizable) alias generation
For table name, for example, 'tMoneyCashOrder', auto-alias should be like 'tMCO'
5 votesThis feature is already implemented in SQL Complete 2.0
- Don't see your idea?