sqlrider

Alex Stuart is a DBA from Manchester, UK, who levelled up from bartender to application support to accidental DBA to full-time Default Blame Accepter.
Primarily a production DBA fond of performance tuning and upgrades, but known to get hands dirty with whatever tool fits the job - Powershell, C#, ASP.NET, breaker bars.
In summer he rides fast bikes on as many racetracks as he can fit in.
In winter he reads and plays guitar and videogames. Ok, sometimes in summer he also does all of those things.
  • Interests: Technology, philosophy, motorbikes, videogames
  • Skills: Performance tuning, Azure, automation

All authors

All authors

Blogs

Learning from Mistakes: T-SQL Tuesday #194

By

We’re a week late, once again my fault. I was still coming out of...

Stupid Things I Did With AI: ASCII Art

By

I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...

Simple Talks Podcasting in 2026

By

I’m in the UK today, having arrived this morning in London. Hopefully, by this...

Read the latest Blogs

Forums

Learning From Breakage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learning From Breakage

Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy

By sabyda

Comments posted to this topic are about the item Python in Action to Auto-Generate...

Adding and Dropping Columns I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding and Dropping Columns I

Visit the forum

Question of the Day

Adding and Dropping Columns I

I have this table in my SQL Server 2022 database: 

CREATE TABLE [dbo].[CityList]
(
[CityNameID] [int] NOT NULL IDENTITY(1, 1),
[CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
I decide to add two new columns for the StateProvince and Country. What code should I use?

See possible answers