Technical Article

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: )

591 reads

Blogs

Why i use a smaller docker image part I

By

What is Docker? Docker is a famous platform for building, shipping, and running container...

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

Read the latest Blogs

Forums

SQL blocking caused by running ALTER VIEW script

By webrunner

Hello experts, One of our developers tried to alter a view and reported to...

script to find the frequent used login information in the sql

By pols

Hi, Kindly some one share the script or query to get the login information...

SQL Server Agent is not expanding and Jobs are not visible

By pols

Hi, We are not able to expand the SQL SERVER Agent. It is taking...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers