Posts
Sort by recent activity
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">
<...
2 semicolons has been inserted
I'm using the most recent version (6.5.0.234 - 24th Feb) of SQL Prompt and got the following issue. Please take a look of the image below.
SQL Prompt doesn't support the pseudo column %%physloc%%
When the query include the pseudo column %%physloc%%, SQL Prompt marks it as an syntax error. But SQL Server will correctly execute the query and gives me the result. Please take a look at the foll...
Is it possible to format SQL script in SQLCMD mode?
Currently I got errors when trying to format scripts in SQLCMD mode. It told me I have syntax errors in my code and has been highlighted.
Thanks.
[feature request]Add a number before each suggested items
Is it possible to add a number before each suggested item in the popup?
Like the snapshot below:
We can only add numbers for the first 10 items (corresponding to 1, 2, 3, 4, 5, 6, 7, 8, 9, 0) if t...
[feature request] Different snippets with the same trigger
Hi,
SQL Prompt does not support different snippets with the same trigger string.
What I want is:
Let's say I have created two snippets:
1. CREATE TABLE .....
2. CREATE DATABASE ....
and both of the...
[feature request] Add 'N' to unicode type literal strings
Hi,
Is it possible to format below codeDECLARE @a VARCHAR(200);
SELECT @a = 'asdf';
DECLARE @b NVARCHAR(200);
SELECT @b = 'asdf';
toDECLARE @a VARCHAR(200);
SELECT @a = 'asdf';
DECLARE @b NVAR...
[feature request] Add semicolon to statements
It would be useful if SQL Prompt can add semicolons to the statements that don't have a semicolon. Please consider it.
Thanks.