Please enable SQL Prompt to have the same behavior with double quotes as with square brackets.

For example, typing:
SELECT * FROM [MyTable]
will allow the expansion of the asterisk, while
SELECT * FROM "MyTable"
does not.

SET QUOTED_IDENTIFIER is ON by default. Also, many Oracle "converts" use the format "SchemaName"."TableName".

When running the formatting, it provides consistency across developers. To make the SQL statements easier to read, the nested JOIN statements should be further indented.
Currently format makes the nested joins look like:
SELECT *
FROM A
INNER JOIN B
ON A.Aid = B.Aid
LEFT OUTER JOIN C
INNER JOIN D
ON D.Cid = C.Cid
ON C.Aid = A.Aid

The following allows seeing the nested joins easier:
SELECT *
FROM A
INNER JOIN B
ON A.Aid = B.Aid
LEFT OUTER JOIN C
INNER JOIN D
ON D.Cid = C.Cid
ON C.Aid = A.Aid

Devart SQL Complete has this incredibly useful feature to execute current statement using a keyboard shortcut. I believe it's CTRL+Shift+E. Sql Prompt needs this. It's a major time saver!

When I right-click on a table and "Select Top 1000 Rows" or "Edit Top 200 Rows", the query should include an alias on the table and have that alias on each row.

This will make it easier to join tables when some column names overlap.

For example:

SELECT fieldA AS aliasA,
fieldB AS aliasB,
fieldC AS aliasC,
..etc...

(pretending all the "as" words were lined up and the sql was in a constant width font.)

Or to add a feature similar to CodeAlignment (http://www.codealignment.com/ForVisualStudio.html)
that would allow a users to align by character.

Auto-complete for PK column values.

Benefits:
Would enable easier navigation in static tables while coding, especially for GUID PKs.

Example:

SELECT *
FROM dbo.EmployeeType
WHERE EmployeeTypeId = '667A29F4-B736-4209-9B0F-0CB564DC6430'

When typing the "=" character (after the EmployeeTypeId) a list of rows to select from is displayed:

EmployeeTypeName CreatedBy CreatedOn
Permanent JoeBlo 20/05/2013
Contract JohnDoe 20/05/2013

When a row is selected in the popup, the correct PK key value is returned.

Add an option to Summarize script feature to show not only the main table, but also all other joined tables

For example with option off (current release)

select from tablea
update tableb
delete from tablec

Turning option on would result in

select from tablea
join tablex
update tableb
join tablex, tablec, tablej
delete from tablec
join tableb

Would it be possible to implement a Visual Studio-like selection of tokens? That would mean, if we have a name like, say, [ThisIsATable_WithAnUnderscore] and I wanted to select via Shift-Ctrl+Left Arrow the term 'WithAnUnderscore' the selection would be expanded not to encompass the whole identifier but only up to the next capital letter or underscore. It would be really helpful as it is in Visual Studio. Thanks for you outstanding creations! :)))

When formatting the SQL, could we have or leave a blank line after the "AS" keyword. I normally put a blank line after the word for readability but everytime I do a format, it takes the line away.

Thanks,

Tom

It would great if there was an un-format SQL command, which would basically un-format the SQL by removing all the carriage returns, tabs, extra spaces, etc. I know it seems odd, but we have several applications that use the SQL via external files, so the formatting will not work, and we end up manually removing all the formatting.

Give preferential treatment to snippets. I use "stop" (select top 10 * from), but I have a database with the word "stop" in it. When I type stop the only thing that shows up in the suggestion list is the object. The snippet isn't even listed.

My preference would be for the snippet to come up first, then I could arrow down if I want the object. Alternatively, include the snippet in the list of suggestions.

When you format:

SELECT x from y

;WITH NumberSequence ( MonthNumber )
AS ( SELECT 1 AS MonthNumber
UNION ALL
SELECT MonthNumber + 1
FROM NumberSequence
WHERE MonthNumber < 12
)

You move the semicolon to the end of the previous command instead of leaving it with the CTE and remove the blank line:

SELECT x from y;
WITH NumberSequence ( MonthNumber )
AS ( SELECT 1 AS MonthNumber
UNION ALL
SELECT MonthNumber + 1
FROM NumberSequence
WHERE MonthNumber < 12
)

Should leave the blank line and semicolon where they are.

Thanks,

Tom

Create a Select/Update/Insert/Delete procedure by rightclick a table.

With option to select columns for each statement.

Convert selected CODE or a complete stored procedure to Dynamic SQL Code.

When you try to add a quote in FRONT of an existing quote, it is ignored and the cursor just moves over the existing one.
It is very frustrating, especially when working with dynamic queries where multiple ' quotes might be required. You end up having to go back and count the number of quote characters on both sides to make sure none were missed.

This happens with closing brackets too, but is especially annoying with single-quotes, since they are also used as opening characters.

Please provide an option to disable this unwanted feature.