Oftentimes when I am writing queries, the results from one column of one query are quickly needed in my next one in an IN clause. I highlight the column of values from the results grid and paste into the query window, and then have to append commas (and for neatness, I delete the line breaks). I would be nice to have an added option the context-menu of the results grid to add a copy as comma separated list (in addition to the current copy and copy with headers options).

When hovering over an alias a pop-up or hint appears which only tells you that it is a table, eg for oe.Job J. Later in code J.Name = @Name. Popup shows:

J(Table).

Drilling down gives the columns which may help.
However if it showed something like:

J = oe.Job (Table)

then this would be a good quick reference eg when trying to understand a long complicated query written by someone else with numerous aliases.

Please provide the option to format IF statements as follows, based on the format settings sample.

IF @productType IN ('a', 'b', 'd', 'g', 'i', 'O', 'Q', 'X', 'Z') BEGIN

----IF @cost <= @compareprice BEGIN

--------PRINT 'Less than $' + CAST(@compareprice AS varchar(20))

----END ELSE BEGIN

--------PRINT 'Exceeds $' + CAST(@compareprice AS varchar(20))

----END

END

When autocompleting a stored procedure statement in the format 'EXEC storedProc @param1 = 0, @param2 0' it would really help if the parameters would initially have the default values defined in the stored procedure (if applicable).

After spending some time refreshing my memory on implicit conversions, and the potentially disasterous affects on performance, the thought hit me...

Wouldn't it be great if SQL Prompt could hightlight potential implicit conversions when I write JOINS or WHERE statements?

I'm not sure how easy this would be to implement but I know everyone at Red Gate is very intelligent and highly creative so you'll find a way. :-)

Step 1: At first I want to comment out all the unused variables.
Note: In these comments there must be a keyword (e.g. UVC To make it different from other comments) which can be helpful to remove it later after proper testing.

Step 2: After some testing(may be in if I find everything works fine I want to remove all the unused variables permanently to make a final copy.

When I point on the object in editor it generates the script for that object. It would be nice to have some kind of dropdown list with checkboxes or something like that to add some extra conditions what objects to generate. For example for table it generates: table code, constrains, indexes... Sometimes I want to see there triggers, maybe permissions, something else.

I don't know how many time a day I end up typing SELECT 8 instead of SELECT *. It would be nice if SQL Prompt could automaticaly detect this and correct it.

Often when reviewing someone else's objects I have to open them and scan through to determine if they are truly read only or if they contain data modification code (delete,update, insert, merge, etc...). It would be most helpful if SQL prompt could show a flag for read only vs data mod objects (when you hover over and click to open the summary window displaying it there would be ideal). It would be best if it could check dependencies (if the object called others)

;
RECEIVE TOP(1)
@h = conversation_handle,
@t = message_type_name,
@b = message_body
FROM Simple_Queue_Target

From the Service Broker Workbench on Simple Talk.

It only moves the semicolon to a separate line. No errors. Ignores "comma at start".

And, yes, the @'s above probably start in column 1, when they're actually in col 5.

It would be helpful if Prompt showed Intellisense where you put the OldName :

EXEC sys.sp_rename @objname = 'OldName', @newname = 'NewName'

I *love* the capture Sql history - it is very useful. It would be just as useful if Sql Prompt could also capture and save off the MDX submitted in SSMS.

When using SQL CMD variables in VisualStudio/SSDT project to support Database references using a Database variable(ex Different database, same server). SQL Prompt is no longer able to resolve objects.

SELECT a.* FROM [$(RefDataBase)].[dbo].[MyTable] a
Then a becomes an "unresolved alias"

Often when working on a database object will type exec procname/select * from view/table. When the desired object is selected with arrow keys a Sourcebox popup appears with a Copy button. A shortcut key to this button would be fantastic. Fingers on keyboard instead of finding mouse.

when creating a WHERE colname IN ('a','b','c')

it would be nice if you could paste a set of rows from excel into SSMS and then add the quotation marks and commas

i.e.

A
B
C

becomes

'A',
'B',
'C'

It would be nice if one could click a button and get the AS keyword between an object name and its alias. This would help with code that doesn't use AS to separate the two. And would also help readability.

Thanks.

Database for the field description and explanation, can increase a list of fields in the quick preview list instructions?