Posts
Sort by recent activity
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...
How to put the OPTION clause on a separate line?
Hi guys,
I have the following query:SELECT
p.Name,
Total = SUM(inv.Quantity)
FROM
Production.Product AS p
INNER JOIN Production.ProductInventory AS inv
ON inv.ProductID = ...
Why the data type sysname is always in lower case?
I have the following code:DECLARE
@objectName sysname,
@objectType CHAR(2);
SET @objectName = N'sysrscols';
SET @objectType = 's';
SELECT * FROM sys.objects WHERE [name] = @objectNa...
Format INSERT INTO...EXECUTE
This is my format settings (you can import into SQL Prompt):<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!---->
<LayoutOptions version="1" type="LayoutOptions">
<...