CREATE TABLE dbo.TestData (
  CityId INT NOT NULL
, CityName NVARCHAR(100) NOT NULL
, LastRecordedPopulation INT NULL
, StateOrProvince NCHAR(2) NOT NULL
)