Posts
Sort by recent activity
Placing parameters on a new line for stored procedures
How can I get SQL Prompt to place the first parameter on a new line? I tried these settings:- Lists --> Place first item on new line = Always- Place subsequent items on new lines = AlwaysIn the pre...
Certificate suggestions support
I noticed that certificates aren't completely supported. Is there any way to get these fully supported?use master
-- sql prompt works for this
create certificate tswift_cert encryption by password ...
Code analysis incorrect - alias
The code analysis for aliases isn't correct. For example, this query:select my_alias = o.name
from sys.objects o
Gives this issue: Old-style column alias via EQUAL sign. It is recommended to spec...
Brackets when scripting stored procedures
Is there any way to disable adding brackets around the database, schema, and stored procedure name when scripting a stored procedure? SQL Prompt is adding it in, even though the stored procedure it...
Logon Triggers Not Supported
I am unable to use SQL Prompt's autocomplete features within a logon trigger. Is there any way this can be supported?
Example:
use master
go
create trigger [trgAudit]
on all server
for logon
as
beg...
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...