Posts
Sort by recent activity
Is it possible to align a subquery with other items?
I have a piece of SQL.SELECT *FROM sys.dm_db_index_physical_stats( DB_ID(), OBJECT_ID(N'Sales.SalesOrderDetail'), (SELECT CAST(index_id AS INT)FROM sys.indexes WHERE name = 'IX_...
SQL Prompt is so slow when I have 255 snippets
I'm using SQL Prompt Version 10.12.1.28146 with SSMS v18.12.1, and I have 255 snippets. When I disabled SQL Prompt suggestion, I can type freely in SSMS and it's very smoothly. But when I enabled S...
How can I convert the new snippet format to old?
I've updated SQL Prompt to SQLPrompt_10.6.7.19129 and I have performance issue, which should be the same to https://forum.red-gate.com/discussion/87783/sql-prompt-version-10-6-0-17688-slow-cursor-m...
Using SQL Prompt with two SSMS instances
I normally need to open multiple instances of SSMS. I found when I add a snippet in the first SSMS, it didn't show up in the second SSMS. If I add another snippet from the second SSMS, it didn't sh...
How to escape $ character in a snippet?
How can I output something like
$tablename$
literally in SQL Prompt? I tried to use back slash or double $ to escape $ but failed. Thanks.
SQL Prompt can't preserve my custom snippets folder setting
I'm using the most recent version of SQL Prompt. I also use a custom snippet folder. Each time I start SSMS, SQL Prompt changed my previous set custom snippet folder to its default value. Please he...
How to create user defined actions like this?
How to create user defined actions like this?
Could you help to confirm if this is a formatting bug?
I have a piece of code:DECLARE @orders TABLE(order_id BIGINT NOT NULL UNIQUE WITH(IGNORE_DUP_KEY=ON))
When I format it, it changed to:DECLARE @orders TABLE ( order_idBIGINTNOTNULL
...
Formatting issue (new line and parentheses)
I have a piece of code and after formatting it using my configuration it looks like this:
INSERT INTO dbo.dept
( id,
name
)
VALUES
(
1,
N'Administration'
),
(
2, N'Sale'
),
(
...
Formatting CTE
Right we have an option to format CTE content's opening parenthesis, is it possible to add an option for the closing parenthesis? I hope we have an option to place the closing parenthesis on a new ...