10 results found
-
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…6 votes -
Collation names enclosed in square brackets is invalid
I have "Enclose identifiers within square bracket" set to "Always", which in most cases are great.
However, collation names are also being enclosed in square brackets, which seems to be invalid.
Please correct.1 voteAdminit (Admin, Devart) responded
Could you please specify what product version you are using?
A video or screenshots would be also of help.
-
SQL Complete does not support parsing SQL with valid PATINDEX function
SQL Complete does not support parsing SQL with valid PATINDEX function
1 voteAdminDevart (_, Devart) responded
Could you please provide us the specific example of this?
-
Remove debug stamp in Releases (keep it for your Debug versions only or verbose mode)
Steps to reproduce:
- run app DebugView
- work with SQL Complete for sometime in SSMS
- keep watching DebugView until you'll see lots of debug messages generated by SQLCompleteExpected: no debug messages in Release binaries
Actual: there are debug messagesPlease chekc all other products for this.
1 voteAdminDevart (_, Devart) responded
We will fix it in one of the next product builds.
-
Alias CTE like tables
When referencing a CTE, the CTE name is also its alias instead of the shortened version. E.g. the CTE NewUsers doesn't get aliased as "nu". Also, when typing "SELECT * FROM NewUsers", navigating to the "*" and hitting tab to expand columns, the expanded column names aren't prefixed with an alias or table name. This could just be a settings issue
1 voteAdminDevart (_, Devart) responded
Could you please describe it in more detail and provide us the scripts?
Screenshots would be also of help.
-
Problem find sorage procedure F12
Problem find storage procedure when select text proceure name do not contain exec.
Example:
exec ProcedureName -this ok
ProcedureName - this error Connot navigate to definition. Connot find referenced object.1 voteAdminit (Admin, Devart) responded
The whole script should be valid. This is by design.
-
Allow the 'on' clause to be aligned with the JOIN clause
"Support" was of no assistance, but I'd like to have my 'On' clause aligned with the join clause, but it's not possible:
from
[ExtendedEvents].[Events] ee -- on new line
join
OtherTable
on -- inline with JOIN
OtherTable.[ID] = ee.[ID]
where1 voteAdminDevart (_, Devart) responded
This can be setup as follows:
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 ‘Open Selected…’ button.
4. Navigate to the ‘SELECT → FROM → JOIN’s’ section.
5. Unselect the ‘Indent ON keyword by 4 columns’ option. -
In 'where' clause align the conditions to allow easier column selection
"Support" were or no assistance. I'd like to align the where clause so that I can column select the conditions, bu aligning the logical operators with the where clause:
where
[collectionid] > 5396 -- alignment
and [sessionid] = 114 -- alignmentcurrently the code gets formatted as:
where
[collectionid] > 5396 -- alignment
and [sessionid] = 114 -- alignment1 voteAdminit (Admin, Devart) responded
Could you please provide us screenshots of the actual and expected results along with the script?
-
code completion not working when db is offline
when db is offline during ssms startup - it won't get code completion.
you have to bring it online and restart ssms1 voteAdminDevart (_, Devart) responded
Could you please clarify if it does not work only for offline databases or for each database on the server?
A video or screenshots would be also of help.
-
Keep the comments when formatting procedures!
Keep the comments when formatting procedures! IT can't be that all comments are removed by the formatting process! That happens to my code when I execute ALTER PROCEDURE!
OR: Give me the option to NOT format my code! I use the Express Version.1 vote
- Don't see your idea?