Rajat Jaiswal

I am Rajat Jaiswal.
I have around 9 years of industry experience.
I have always found technology and programming to be very interesting and for me, programming is not something that ends when I step out of the office.
I love exploring new stuff and databases amuse me the most.
I started blogging in 2006 on http://rajatjaiswal.blogspot.com and http://indiandotnet.wordpress.com, http://sqlRaaga.blogspot.com
I am quite active on my blogs and often post entries on Microsoft technologies like C#, ASP.NET, SQL Server, Silverlight & Windows Phone 7.
  • Interests: I am always interested in Microsoft Technology specially asp.net & SQL server. Other than this I love Singing ,dancing and playing musical instruments.

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