This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Write your queries more quickly with SQL Prompt from Redgate
The SQL Prompt utility from Redgate has an annual subscription cost, but on the plus side it will complete tedious joins for you (among many other things).

Posted by Andy Brown on 26 April 2023

In this blog

What SQL Prompt lets you do
Installing SQL Prompt
How much does SQL Prompt cost?

Write your queries more quickly with SQL Prompt from Redgate

This blog explains what the SQL Prompt add-in is and does, so that you can decide for yourself whether to install it.

Thanks to Nathan from ista Energy Solutions for bringing this to my attention (although when I excitedly told the other Andrew in the office about my discovery he pointed out that this tool has been around for many years!).

What SQL Prompt lets you do

If (like me) you spend much of your working life writing SQL queries, you'll appreciate anything which can make the task quicker. Imagine a tool which suggested tables for you, and showed you their columns:

You can click on any table in the suggestion list to see the columns it contains.

Above all, imagine that it suggested possible joins for you:

I get so bored of typing joins - I love this idea!

At any time you can press Alt + S to bring up a list of possible commands (in alphabetical order):

Just one of the many extra commands that you can run.

Installing SQL Prompt

You can install a free 28-day trial of SQL Toolbelt (of which SQL Prompt is a part) from the Redgate site:

There are many more tools in the toolbelt than just SQL Prompt, but this was the one I was interested in.

After downloading the software and choosing what you want to install, you can then activate your trial:

Refreshingly, you don't need to create an account or type in any credit card information to start a trial.

You then see this message:

When you start up SQL Server Management Studio you'll now be asked whether you want to invoke SQL Prompt.

How much does SQL Prompt cost?

At £894 per user per year SQL Toolkit is not cheap, but you can just take out a licence to use SQL Prompt:

Whether you think it's worth spending nearly £150 to save yourself some typing is up to you!

And with that, I will now uninstall SQL Prompt, since I need a clean copy of SSMS for displaying on training courses!

Some other pages relevant to the above blog include:

This blog has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Visual C# training

Excel training courses

Power Automate training

Power BI / DAX training

Python training courses

SQL training courses

VBA (macros) training

Site map

Terms & Conditions

BLOGS BY TOPIC

BLOGS BY AUTHOR