SQL PROMPT

Removing the Square Bracket Decorations with SQL Prompt

  • Article

If you avoid illegal characters and reserved words in your identifiers, you'll rarely need delimiters. Sadly, SSMS applies square bracket delimiters indiscriminately, as a precaution, when generating build scripts. Phil Factor provides a handy function that adds quoted delimiters only where they are really needed and then sits back and lets SQL Prompt strip out any extraneous square brackets, in a flash.

2020-01-29

Blogs

2020 Advent of Code–Day 1

By

This series looks at the Advent of Code challenges. I started the Advent of...

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)

By

Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...

One Chart at A Time Video Series

By

Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...

Read the latest Blogs

Forums

SUM multiple tables GROUP BY column

By milo1981

I have the following SQL Server 2005 tables: create table Cars ( CarID int,...

SUM multiple tables GROUP BY column

By milo1981

I have the following SQL Server 2005 tables: create table Cars ( CarID int,...

Interesting bug in SQL 2016 CHOOSE

By ScottPletcher

While trying, in SQL 2016 (13.0.5850.14), to see if CHOOSE allowed an inline query...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers