Redgate Hub

Topic: SQL Code Snippets

All products

All databases

All levels

SQL Prompt logo

Driving up database coding standards using SQL Prompt

A strategic view of how a development team can use SQL Prompt to establish and share coding standards, through code analysis rules, formatting styles and code snippets. Read more

SQL Prompt logo

Customizing the SQL Prompt built-in snippets: a better ALTER TABLE ADD (ata) snippet

Phil Factor improves SQL Prompt's built-in ALTER TABLE ADD (ata) snippet so that it enforces certain coding standards, such as specifying whether the column accepts NULL values, and ensuring the new column is well-documented. Read more

SQL Prompt logo

How to use the SQL Prompt snippet placeholders for selecting and copying text

Phil Factor demonstrates the power of placeholders in SQL Prompt Snippets, for selecting and copying text. They make it very easy to build queries by dragging-and-dropping from the SSMS object explorer, and also to save queries as reusable views or inline table valued functions. Read more

SQL Prompt logo

Why your Development team needs SQL Prompt

While everyone knows SQL Prompt for its code completion and IntelliSense features, a lot of its extra value comes from features that allow the development team to standardize coding practices and drive up code quality. Read more

SQL Prompt logo

A day in the life of a developer with SQL Prompt

Write, refine, format and test a reporting query before lunch then refactor a database, and retest the new design, afterwards. All in a day's work for a developer armed with SQL Prompt. Read more

SQL Prompt logo

How to record T-SQL execution times using a SQL Prompt snippet

Phil Factor shares a SQL Prompt snippet called timings, which he uses as a standard testbed for getting execution times for procedures and functions. Read more

SQL Prompt logo

SQL Templates and Code Snippets in SSMS and SQL Prompt

Phil Factor explains the uses and limitations of native SSMS templates and snippets, and then demonstrates the extra versatility that SQL Prompt snippets provide. Read more

SQL Prompt logo

The SQL Prompt Functionality Finder

You have SQL Prompt, but are you aware of all the things it can do and how to get it to do it? Phil Factor provides a handy table to make it obvious. Read more

SQL Prompt logo

Faster SQL Server troubleshooting using SQL Prompt snippets

SQL Prompt logo

SQL Prompt

Quick SQL Prompt tip – using the CDB snippet

Previous Next

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Hub

Topic: SQL Code Snippets

Driving up database coding standards using SQL Prompt

Customizing the SQL Prompt built-in snippets: a better ALTER TABLE ADD (ata) snippet

How to use the SQL Prompt snippet placeholders for selecting and copying text

Why your Development team needs SQL Prompt

A day in the life of a developer with SQL Prompt

How to record T-SQL execution times using a SQL Prompt snippet

SQL Templates and Code Snippets in SSMS and SQL Prompt

The SQL Prompt Functionality Finder

Faster SQL Server troubleshooting using SQL Prompt snippets

Quick SQL Prompt tip – using the CDB snippet

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Topic: SQL Code Snippets

Cookies on red-gate.com