10 results found
-
F12
По F12 объект ищется в текущей базе. Но поиск не срабатывает и падает с ошибкой если:
- В базе стоит фильтр, и обьект не может быть найден при текущем фильтре.
- Если в окне студии открыт например код процедуры - и он трактуется как некорректный, например из за того что процедура уже есть в базе, а открытый скрипт начинается с CREATE PROCEDURE... То по F12 также выпадет ошибка. Нужно вручную заменить CREATE например на ALTER, только в этом случае поиск по F12 опять сработает.
Более того, вцелом неудобно сначала по F12 делать поиск, а потом дополнительно на найденом объекте по выпадающему меню…
1 vote -
Refactoring suggestions
I really love the refactoring features, but came across 2 things that might be addressed.
when renaming procedure variable and the same variable name is used in other SP that is called using explicit variable assignment, e.g.
EXEC dbo.otherSp @variable = @variable,
the other SP variable gets renamed as well
(e.g. rename
@variable to @newName creates
EXEC dbo.otherSp @newName = @newName
instead of
EXEC dbo.otherSp @variable = @newName)
when variable is part of an EXEC command and parameter contains assignment operator, only the variable following an assignment operator should be renamedwhen leaving table alias as it is and changing…
1 vote -
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 -
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) respondedCould 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.
-
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) respondedThis 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. -
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.4 votesAdminPMs (Admin, Devart) respondedThe whole script should be valid. This is by design.
-
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 voteAdminPMs (Admin, Devart) respondedCould you please provide us screenshots of the actual and expected results along with the script?
-
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) respondedWe will fix it in one of the next product builds.
-
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) respondedCould you please provide us the specific example of this?
-
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 voteAdminPMs (Admin, Devart) respondedCould you please specify what product version you are using?
A video or screenshots would be also of help.
- Don't see your idea?