Posts
Sort by recent activity
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.
(un)Indent the body of a store procedure of function
I have the following code:CREATE PROCEDURE dbo.test
@test1 NVARCHAR(MAX) = 'All',
@test2 NVARCHAR(MAX) = 'All'
AS
BEGIN
SET NOCOUNT ON;
END
GO
Is there a way to *not* ...
Format of EXECUTE statement
For now there is an option "For EXECUTE statements, place each parameter on new line". I want to know if it's possible to add an option like "if number of parameters are greater than 4, then place ...
Is it possible to add an option to format all @@variables?
@? I want to get a consistent case for all those variables. Now there seems no this option and I have both lower case and upper case in my code.
Thanks.