You may not have heard about it yet, but three helpful features were recently added to SQL Prompt that are activated when you right-click on the Results Grid in SQL Server Management Studio (SSMS).
1. Copy as IN clause
This feature is available when you have values from a single column selected. You can select the entire column, parts of the column, or even single values in the column. Right-click and select Copy as IN clause.
The values you selected will be formatted as a list that you can paste into a query:
2. Script as INSERT
When you select the entire grid, adjacent rows, adjacent columns, a single cell, or a block of cells, this second feature is now available. Simply right-click and select Script as INSERT.
A new tab is automatically created with a script containing the values you selected. This script creates a temp table with the column names and data types from the original query. It inserts the selected values and drops the temp table. This is such a time-saver for me, even if I only need the INSERT part of the script.
3. Open in Excel
When you select the entire grid, adjacent rows, adjacent columns, a single cell, or a block of cells you can also right-click and select Open in Excel.
This opens a new Excel file with the selected values and column names in the first row. This is perfect for when I quickly need to send some data to our business users:
Now watch the video
If you’d like to see a demo of the new features in action, watch this short video:
If you don’t like the way the auto-generated code looks, by the way, you can also use the new SQL Prompt formatting options to make it more attractive or better fit the style your team uses.
If you’re not a SQL Prompt user, download a free trial and see how much more productive you can be writing code every day.
Like this? Share it with other SQL professionals using the social sharing buttons below. Simply tweet: I’ve just read @cathrinew’s blog on 3 useful Results Grid features in #SQLPrompt – see the #SuperSQLTip at http://rd.gt/2mBQ1lr
This is a guest post from Cathrine Wilhelmsen. Cathrine is a Friend of Redgate and Microsoft Data Platform MVP, working as a Data Warehouse and Business Intelligence consultant.
She loves teaching and sharing knowledge, and is active in the SQL Server and PASS communities as an author, speaker, blogger, organizer and chronic volunteer.
She can be found on Twitter and she regularly blogs about technology issues.
Also in Hub
The right to be forgotten is one of the main features of new data protection legislation across the globe. Under Article 17 of one such piece of legislation in Europe, the GDPR, individuals have the r...
Also in SQL Prompt
The syntax of the TOP clause insists on a bracketed, or parenthesized, expression as its first argument, so that TOP 34 should, strictly speaking be TOP (34), although if you are just supplying a nume...
Also in Product learning
Most organizations are finding that the size and number of databases that need to be monitored is increasing, unlike the number of people available to do the work. Now that it is possible for the orga...
Also about SQL Prompt
Code analysis is a useful technique for identifying potential issues in your code base, and ensuring that it adheres to your pre-defined standards, so that you can release your software product with m...
Also about SSMS Results Grid
Within SSMS, when executing a query, we can view the query results in a grid, or tabular, format (Ctrl-D), as plain text (Ctrl-T), or we can write them to a plain-text reporting (.rpt) file using Ctrl...