Posts
Sort by recent activity
TAB expands * instead of indenting
If you use this code:SELECT
*<end selection>
FROM dbo.backupfile
WHERE
backup_set_id > 10<start selection>
And start selecing text from the bottom (as indicated) and type a TAB...
SP-2889 Roaming profiles fix
I see the announcement that says the latest fix includes:
SP-2889 Roaming profiles don't work with the registry key fix
Can you tell me exactly what has changed in the latest version in relation to...
Refresh Suggestions Doesn't
If a table is updated in a different DB and you select the "Refresh Suggestions" the changes are not picked up.
Say you create a table:
CREATE TABLE Model.dbo.Test (Test VARCHAR(1) NULL);
and then ...
Suggestion Order Changes
I am using SQL Prompt 4.0.3.12 and have noticed that the order of the suggestions changes when it shouldn't.
For instance try this:
SELECT
*
FROM msdb.dbo.backupfile B
INNER JOIN msdb.dbo.<cu...
4.0.3 Adds ' when it shouldn't while indenting
Given this code:
SELECT
<select start>'Test' AS Field1,
'Test2' AS Field2,
''<select end> AS Field3
INTO #Temp
And having the code between <select start> and <select end> selected wh...
Field Suggestions That Start with a Number
It would be nice if SQL Prompt would offer suggestions for fields that start with numbers when you start typing the field name even if you leave off the [.SELECT
1 AS [1Field],
2 AS &...
4.0.3 only lists some users for GRANT
The release notes for 4.0.3 say: "GRANT Statement should have list of USERS" I guess the keyword there is should.
Given:GRANT SELECT ON dbo.<table> TO <cursor>
It brings up suggestion...
Suggestions drop as name typed
Given this code:USE msdb;
SELECT
backu<cursor>
FROM dbo.backupfile A
It suggests: backup_set_id, backup_size, and backupfile, etc..
Backupfile is the table and is aliased as A so it isn'...
Doesn't capitalize keyword CASE
With this code:
SELECT
*
FROM msdb.dbo.backupfile
WHERE
case<cursor>
When I type a space SQL Prompt does not convert it to upper case. I think the problem is that there is a table named...
Script View Request
I think it would be great if the code displayed in the script view when you are picking from a suggestion could be run through the Format SQL process so when you copy something to use as a template...