Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform

SQL Prompt users can now share formatting style or code snippets in designated Team spaces on the Redgate Platform. Louis Davidson explains how it works. Read more

Exploring New SQL Prompt Features in SQL Toolbelt and SQL Toolbelt Essentials

Roseanna Whitelegg explores new SQL Prompt functionality that has been added to SQL Toolbelt and SQL Toolbelt Essentials to help teams increase their productivity, improve code quality, and make collaboration easier. Read more

Bulk Formatting of the SQL Server SQL Files

How to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch. Read more

SQL Prompt ALT S Magic

Use the SQL Prompt Command Palette to find and execute 'hidden' SQL Prompt functionality, plus any of the common SSMS commands, as well as search for database objects. Read more

How to Compare Two SQL Prompt Styles

A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code. Read more

Using Aliases in SQL Prompt

Phil Factor explores the role of table aliases, explaining when they are required, and their general purpose otherwise, the need for sensible naming of aliases, and how SQL Prompt handles them. Read more

SQL Prompt by Keyboard

Phil Factor shares a handy keyboard shortcut diagram that reveals some of the most useful of Prompt's keyboard shortcuts, and a wallchart showing every piece of Prompt functionality, what it does, where to find it in the various menus, and of course its keyboard shortcut. Read more

Controlling how SQL Prompt Formats your Code: The Knobs and Dials

Phil Factor explores and discusses the current state of the art in SQL Formatting, as done automatically by SQL Prompt. Read more

How to Apply Non-Standard SQL Formatting Using SQL Prompt

SQL Prompt not only will format your code exactly as you want, but will also help you switch quickly to an alternative style, or to apply exceptions to certain parts of a SQL script, where your preferred style isn't what's required. Read more

SQL Prompt as a Layout Tool: A Survival Guide

Phil Factor's guide to taming SQL Prompt code layout options, and getting it to format code exactly the way you like it. Read more

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Product articles
SQL Prompt
SQL Formatting and Styles