Run selected script as Database Query (.dqy) in Excel
Microsoft Excel has a perfect possibility to run direct database queries and use results for further
processing: as simple data table, as base for Pivot tables and Charts. However, there are some clicks to do, before you get your query executed in Excel.
SSMSBoost adds 1-click functionality to complete this:
- Select query, that you want to export for execution in Excel
- Execute SSMSBoost Menu->Query->Run in MS Excel command
- SSMSBoost will create Database Query (.dqy) file, passing selected SQL Statement and current connection information
- File is now passed to Excel for further processing. It might be necessary to adjust security settings in Excel to allow processing of ".dqy" files
Note: Excel has some rules, that your query must fulfill. You will find detailed documentation on the Internet, but to keep it short: it must be single SQL query, returning one dataset.
Make sure you check SSMSBoost Settings->Database Query (.dqy)
for fine-tuning options. For SQL Server native authentication
SSMSBoost can export connection password in clear text form, which might be a big problem, if you are going to give .dqy file to other persons. And yes - this is a
workaround how to restore forgotten SQL Password
for some connection, that is still present in your recent connections list.