Posts
Sort by recent activity
spaces
Hi !
Formatting the following statement for example will lead to additional spaces:
SELECT * FROM sys.all_sql_modules WHERE uses_native_compilation = 1;
GO
--formatted
SELECT * FROM sys.all_sql_mod...
Formatting adds unneeded spaces
Hi!
The formatting seems to add additional spaces after the last SELECT and WHERE which are unneeded.
Would be nice to get this sorted -thanks!
--get the transactions covered by the active CFPs
DE...
Formatting fails
Hi!
The following statement fails when trying to format.
Guess the reason is that the file_name is not wrapped in brackets, which should be done by SQL prompt for my understanding.
SELECT
fil.name ...
In memory DDL
Hi!
The following statements are not supported by the IntelliSense.
Would be nice to add the functionality - thanks!
DROP TABLE IF EXISTS dbo.Product;
GO
CREATE TABLE dbo.Product
(
ID int NOT NULL
...
Format current statement
Hi!
It would be nice to have the option to format the current statement only to avoid reformatting everything in the document.
At the moment I need to highlight the statement I would like to format...
cte formatting fails
Hi !
The formatting on the following statement fails despite of the fact that parsing and executing is fine.
/*
Author: strat8
Create date: 2016-11-09
Revision History: yyyy-mm-dd Revisor...
execute current statement fails
Hi !
Execute current statement will not work for this code but executing from SSMS will work:
CREATE VIEW dm_db_index_usage_stats
AS
SELECT
i.name AS index_name
, i.index_id
, i.type_desc AS index_...
vertical scroll bar
Hi!
Edit Formatting Style will not show a vertical scroll bar for the left panel. So you need to maximize the entire window to see all topics.
Would be good to have a scroll bar implemented as done...
Join Fromat wrong
Hi!
Version 7.3.0.587
BTW It would be helpful to allow to copy the version number from the about SQL Prompt window!
--one in_row_data allocation unit and one additional row_overflow_page
SELECT
OBJ...
Comments are formatted wrong
Comments are formatted wrong
SQL Prompt 7.3.0.437 will format the following
/*******************************************************************************
troubleshooting queries - query_hash an...