Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
546 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
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). |
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!).
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.
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.
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:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.