Muthusamy Anantha Kumar, a.k.a. MAK, has more than 10 years of experience in Information Technology including database Administration, System Analysis, Design, Development and Support of MS SQL Server 2005/2000/7.0/6.5/6.0/4.X for production/development/testing.

MAK started his first consulting service “JVCC” in Trichy, Tamilnadu, India. Then JVCC was matured to become “Softech Systems”, Chennai, Tamilnadu, India. MAK started teaching when he was 18 and continued teaching. As a part of service to the community, MAK’s started teaching MS-DOS, Word star, Lotus 123, dBase III +, C language, Autocad etc, MS-office, . He made more than 200 students aware of computers, programming languages and databases. MAK continued his teaching by teaching SQL Server administration and produced more than one hundred Professional Database Administrators.

MAK wrote many online articles for DatabaseJournal. He also wrote article for sql-server-performance.com. Now he is writing for us as well.

All authors

All authors

Blogs

Who’s the Winningest Coach (with AI Help)

By

I was listening to the radio the other day and the hosts were discussing...

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...

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