Comments
Sort by recent activity
Hi zhiyounet,
We have just released a new stable build (7.5.0) which contains a fix for this bug! See here for more information.
Please let us know if this fixes your issue.
Thanks,
James / comments
Hi zhiyounet,
We have just released a new stable build (7.5.0) which contains a fix for this bug! See here for more information.
Please let us know if this fixes your issue.
Thanks,
James
Hi zhiyounet,
Thanks for your post!
This sql text collapse bug is a known issue. We have a a fix for it locally which will be contained in our next 7.5 beta release.
Hope this helps!
James / comments
Hi zhiyounet,
Thanks for your post!
This sql text collapse bug is a known issue. We have a a fix for it locally which will be contained in our next 7.5 beta release.
Hope this helps!
James
Hi Tony,
I'm sorry you're having this issue! It does seem very strange. I'm pretty sure that restarting SSMS will fix it, but if it didn't then let us know.
Unfortunately there's not much we can do without more reproduction steps, but if the issue starts appearing more regularly then let us know and we'll take a closer look at it.
Thanks,
James / comments
Hi Tony,
I'm sorry you're having this issue! It does seem very strange. I'm pretty sure that restarting SSMS will fix it, but if it didn't then let us know.
Unfortunately there's not much we can do...
Hi woj123,
Thanks for reporting this issue. It seems to be a problem with the SQL Server 2016 DROP IF EXISTS syntax.
I've logged this in our system and one of the team will look into it soon [image] .
Regards,
James / comments
Hi woj123,
Thanks for reporting this issue. It seems to be a problem with the SQL Server 2016 DROP IF EXISTS syntax.
I've logged this in our system and one of the team will look into it soon .
Rega...
Hi sunibla,
Thanks for your feedback!
I agree, the current functionality disabling the column picker after qualifying the table name doesn't make much sense.
I've logged this as an issue and will let you know when it's been fixed.
Thanks,
James / comments
Hi sunibla,
Thanks for your feedback!
I agree, the current functionality disabling the column picker after qualifying the table name doesn't make much sense.
I've logged this as an issue and will l...
Hi Broye,
I think you're looking for the Qualification options, under SQL Prompt > Options > Inserted Code > Qualification. There is also an option to toggle Qualifying object names under SQL Prompt > Options > Format > Actions.
However, please note that sometimes SQL Prompt will always qualify inserted object names to avoid incorrect SQL, for example when inserting into a non-default schema or when column names would be ambiguous without qualification.
Hope this helps!
Thanks,
James / comments
Hi Broye,
I think you're looking for the Qualification options, under SQL Prompt > Options > Inserted Code > Qualification. There is also an option to toggle Qualifying object names under SQL Promp...
Hi LAtkinson,
Thanks for your feedback!
Unfortunately, SQL Prompt currently does not have shortcuts for the 'Add Commas' or the 'Add commas and quotes' actions.
To spend less time scrolling it is possible to filter the Actions List using the search box, to find the specific action required : [image]
Additionally, it is possible to implement the same functionality in a snippet which is accessible from the top of the Actions List by using the $SELECTEDTEXT$ and $CURSOR$ placeholders, similarly to the BEGIN...END block snippet (be).
Hope this helps!
Thanks,
James / comments
Hi LAtkinson,
Thanks for your feedback!
Unfortunately, SQL Prompt currently does not have shortcuts for the 'Add Commas' or the 'Add commas and quotes' actions.
To spend less time scrolling it is p...
Hi MattH,
Sorry that you're having this problem.
I think this is possible using the new formatting styles. To use it, go to SQL Prompt > Options > Labs > Experimental Features and select the ‘Use new formatting styles’ checkbox.
You can set commas to align before list items using the option Lists > Commas > Place commas before items.
Hope this helps!
Thanks,
James / comments
Hi MattH,
Sorry that you're having this problem.
I think this is possible using the new formatting styles. To use it, go to SQL Prompt > Options > Labs > Experimental Features and select the ‘Us...
Hi Torsten,
I've been looking into this issue more, and we’re considering an implementation change related to comma alignment inside indented parenthesis.
We think it makes more sense that when you align commas 'To Statement', the 'Statement' refers to the containing parenthesis, instead of the overall statement.
To use your example, this would be the formatted code : CREATE DATABASE MemoryOptimized
ON PRIMARY
(
NAME = MemoryOptimized_data
, FILENAME = '$(DataPath)MemoryOptimized_data.mdf'
, SIZE = 256MB
)
, FILEGROUP MemoryOptimized CONTAINS MEMORY_OPTIMIZED_DATA
(
NAME = MemoryOptimized_folder
, FILENAME = '$(DataPath)MemoryOptimized_folder'
)
LOG ON
(
NAME = MemoryOptimized_log
, FILENAME = '$(LogPath)MemoryOptimized_log.ldf'
, SIZE = 128MB
);
ALTER DATABASE MemoryOptimized
SET RECOVERY FULL;
GO
We would be interested in your opinion of this, compared to your original example.
Any other suggestions would be greatly appreciated!
Thanks,
James / comments
Hi Torsten,
I've been looking into this issue more, and we’re considering an implementation change related to comma alignment inside indented parenthesis.
We think it makes more sense that when y...
Hi Tony,
Thanks for your post! We've managed to reproduce this issue here and are working on a fix now.
Thanks,
James / comments
Hi Tony,
Thanks for your post! We've managed to reproduce this issue here and are working on a fix now.
Thanks,
James