Guest Blogger:
Cathrine Wilhelmsen

This is a guest post from Cathrine Wilhelmsen. A Friend of Redgate and experienced SQL Server data warehouse architect and business intelligence developer, Cathrine is a Community Evangelist for PASS and a Microsoft MVP.

She dedicates her time to growing the global community of Microsoft data platform professionals and is also a board member of the Microsoft Data Platform User Group Norway, and the main organizer of SQLSaturday Oslo.

She can be found on Twitter and she regularly blogs about technology issues.

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:

SSMS Results Grid 1

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.

SSMS Results Grid 2

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:

SSMS Results Grid 3

Now watch the video

If you’d like to see a demo of the new features in action, watch this short video:

Bonus tip

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

Share this post.

Share on FacebookShare on Google+Share on LinkedInTweet about this on Twitter

Related posts

Also in Blog

Moving from application automation to true DevOps by including the database

The recent State of Database DevOps Report revealed that within two years, 80% of companies will adopt DevOps. That’s an interesting finding in itself, but the report also showed that 75% of compani...

Also in Redgate products

Extending DevOps practices to SQL Server databases – DevOps webinar Q&A

Even with the right tooling, it can be tricky figuring out how to get an automated database deployment pipeline up and running. That's why each month we host an hour-long DevOps webinar with an end-to...

Also about SQL Prompt

SQL Prompt to the rescue with tab coloring

When you’re hard at work, it’s all too easy to make a mistake as you rush to get a job done. Say, for example, you have a QA database you need to get rid of. You run a query to drop it and then…...