Posts
Sort by recent activity
keywords as alias issues
When using the "Format SQL" feature, it's failing/removing brackets when the alias is a SQL keyword.select top 1 [start] = 'wwww', [end] = 'xxxx'
from sys.objects o
select top 1 ...
Remove Unnecessary Square Brackets Exceptions
Is there a way to have the "Remove unnecessary square brackets" feature to ignore brackets around keywords?
For example, if I had this query:
select
f.[katy_perry_id]
,f.[name]...
GRANT on Schema syntax missing suggestions
The GRANT on schema syntax is missing the "to" and user name suggestions.
Example:grant select on schema::tswift to [katyperry]
SQL Prompt gives the correct suggestions up to the schema n...
Some stored procedures lose db/schema reference
SQL Prompt is removing the database/schema when I try to type in the fully qualified name, when the database name/schema should not be removed. I haven't tested all types of procedures, but I notic...
Default values for stored procedure not assigned correctly
When Prompt fills in the default values for the parameters, they are not correct when the default is NULL for the parameter.
For example:create procedure dbo.DataTypes
@bigint bigint = null
,@bi...