Posts
Sort by recent activity
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 ...
Formatting issue
I have a piece of code:SELECT
OBJECT_SCHEMA_NAME(c.object_id, DB_ID())schema_name,
OBJECT_NAME(c.object_id) object_name,
c.name column_na...
Could you tweak the suggestion UI a little bit?
As you can see in the snapshot, the suggestion name and description equally split the space, in this case the name column has more space than it needs but the description column doesn't have enoug...
The most recent version of SQL Prompt make SSMS hung
I'm using the most recent version of SQL Prompt and it makes SSMS hung several times. When I type some text and triggers the suggestion, SQL Prompt can show the suggestion window but then it disapp...
Can't format the pseudo column %%physloc%%
There is an undocumented column in SQL Server called %%physloc%%. You can get more information from here at http://www.sqlskills.com/blogs/paul/sql ... -function/ It's undocumented but it's very us...
Could you add multi-line default value for a tab stop?
Right now it's impossible to add a multiple line default value for a tab stop in a snippet. The only way is to edit the snippet xml file directly. After that SQL Prompt can successfully recognize i...
Is it possible to add the reverse feature of inline exec?
It's great you guys added the "inline exec" feature in the most recent build. Its reverse feature sometimes is useful too. Is it possible to add "inline exec"'s reverse feature?
Thanks and happy Th...
Is it possible to programmatically modify text at tab stops?
In SQL Prompt snippets, we can use $tab_stop$ syntax to define a tab stop position. Currently the only thing we can do against a tab stop is set its default text. I want to know if it's possible to...