Automate renaming columns

This script finds and renames columns that begin with a digit, contains a space, or contains a hyphen, so that it is no longer necessary to put brackets around the column names. This is useful in situations such as when an application doesn't automatically put brackets around column names when passing queries to a SQL […]

2006-04-12 (first published: )

583 reads

Blogs

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Welcome to the Azure Data Community, empowered by Microsoft

By

After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...

Daily Coping 24 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL Server 2019 PMEM

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2019 PMEM

Query Optimizer Suggests Wrong Index and Query Plan -- Why?

By Mike Byrd

Comments posted to this topic are about the item Query Optimizer Suggests Wrong Index...

UX Matters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item UX Matters

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers