SQL PROMPT

External Article

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

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Copying an old database to a new database

By paul 69259

Hi All, I've got a write a program to copy the data from one...

Transaction log full due to LOG_BACKUP

By JasonO

1 of my production database's transaction log file is full due to some backup...

Calender Error in SSRS with SSAS Tabular Source

By RADISSOUFAN

I have a report which get a Date Parameter.. I don't want to display...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers