When I use SSMS to query the data and use "open in Excel", the exported “. Xlsx” is too old, which will cause the digital content to become 0 after WPS or other form software is opened. This problem has lasted for a long time. I hope your company can upgrade and handle it accordingly. Thank you Very Much

It would be great to be able to script out a comma separated list of the column names from the result grid. Not the data values, but the colum names. Quite often i run queries that return columns from multiple tables and want to create an insert statement with named columns from that result set.

A competitor has that capability and I use it dozens of times a day. Either by selecting all column names from the result set or just highlighting the ones that you want.

Support Azure multi factor authentication for accessing Azure SQL Databases.

When Place Begin - End statements on new line is selected it doesn't appear to work as part of an If statement. This makes the begin and end difficult to find

Merge Command Formatting

For MERGE commands there is no way to make the conditional requirements with 'ON' follow the same style as JOIN's ON. I noticed back on 5/17/2017 there was a closed 'Merge command formatting options' through the User Voice, stating that an experimental feature was available for SQL Prompt 7.4. What happened? In my 10.1.7.15015, within the formatting styles, there is no area for MERGE like there is for JOIN.

We have code littered with IIFs that we would like to convert to CASE. Logically this is straightforward, but achieving it swiftly is proving more difficult. A regex takes care of the simple ones, but the ugly ones with nested functions across multiple lines and all sorts are proving far more difficult.

Would it be possible to add a feature to SQL Prompt to refactor IIFs into CASE statements? Thanks

Include a feature in formatting to include / exclude JOIN type.

For Example
LEFT OUTER JOIN would become LEFT JOIN and vice versa

Not sure this is so useful on the INNER keyword but the OUTER would be useful where people have different styles but we want to standardise work.

In the suggestion box primary key/foreign keys are visually marked. I would like to see this in the objects definition box (Summary tab) as well.

Also it might nice to be able to select columns in there and add those columns to the qury

When formatting SQL, it would be good to have the option to put the item following an AND/OR on a new line and align it, so instead of:

WHERE

OutgoingResults.LoadDateKey = 20191106

AND OutgoingResults.FeedName = 'TestFeed'

we have

WHERE

OutgoingResults.LoadDateKey = 20191106

AND

OutgoingResults.FeedName = 'TestFeed'

When I am composing a script in Multi-Script, I'd like to have the editing settings available. Include variable/column name completion, keyword formatting, indention, etc..

Fix "Script as INSERT" functionality with dates.

Currently when I use this great functionality all the datetime fields will get a form N'1900-01-01T00.00.00'.

Unfortunately the Finnish SQL server settings does not recognise that and running this script gives an error "Msg 241, Level 16, State 1, Line 2
Conversion failed when converting date and/or time from character string.". I have not been able to find a way to change that date format in SQL Prompt Options.

I would like to see intellisense provide you a list of backup devices that are created when you use the backup database key words.

Backup database [database names in drop down] to [ disk, file, Url, backup devices in dropdown]

Would LOVE SQL Prompt to do a silent upgrade, without the need to "promote" admin privledges, nor close Visual Studio / SSMS. Love the upgrades, but they are frequent, and the installation process is disruptive.

'Script object as alter' (F12) works in ALTER statements but not in CREATE OR ALTER statements like. It would be nice if it also worked for the latter.

Example:
'CREATE OR ALTER VIEW [MyView] AS SELECT 1 AS Col1;'
If I right-click on [MyView] in the above code snippet and select 'Script object as ALTER' (or hit F12), I would expect SQL Prompt to script the object if it exists.
Currently nothing happens.

Please add Prompt features when connecting to a Snowflake database

When I have a table with multiple indexes and I want to determine if a certain column or group of columns are part of an index, I basically have to script all of the indexes.
I would like to be able to hover over an index name in the Object Explorer and have SQL Prompt display the index definition without having to script it.
Same with constraints.