/* insert data */ INSERT INTO dbo.States (Name, Abbreviation, Capital, Year, ID) VALUES ('Alabama', 'AL', 'Montgomery', 1819, 1); INSERT INTO dbo.States (Name, Abbreviation, Capital, Year, ID) VALUES ('Alaska', 'AK', 'Juneau', 1959, 2); INSERT INTO dbo.States (Name, Abbreviation, Capital, Year, ID) VALUES ('American Samoa', 'AS', 'Pago Pago', 1899, 3); INSERT INTO dbo.States (Name, Abbreviation, Capital, Year, ID) VALUES ('Arizona', 'AZ', 'Phoenix', 1912, 4); INSERT INTO dbo.States (Name, Abbreviation, Capital, Year, ID) VALUES ('Arkansas', 'AR', 'Little Rock', 1836, 5);