This Microsoft SQL script was used to create a database table named colbert_stateFacts with fields stID, state_name, state_capital, state_code, state_bird and state_flower. The script then inserted records into the new table.
CREATE TABLE [dbo].[colbert_stateFacts]
(
[stID] [int] IDENTITY(1,1) NOT NULL,
[state_name] [nvarchar](50) NOT NULL,
[state_capital] [nvarchar](50) NOT NULL,
[state_code] [nvarchar](2) NOT NULL,
[state_bird] [nvarchar](50) NULL,
[state_flower] [nvarchar](50) NULL
)
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Alabama', 'Montgomery', 'AL', 'Yellowhammer - Northern Flicker', 'Camellia')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Alaska', 'Juneau', 'AK', 'Willow Ptarmigan', 'Forget Me Not')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Arizona', 'Phoenix', 'AZ', 'Cactus Wren', 'Saguaro Cactus Blossom')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Arkansas', 'Little Rock', 'AR', 'Mockingbird (Northern)', 'Apple Blossom')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('California', 'Sacramento', 'CA', 'California Quail', 'California Poppy')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Colorado', 'Denver', 'CO', 'Lark Bunting', 'Rocky Mountain Columbine')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Connecticut', 'Hartford', 'CT', 'American Robin', 'Mountain Laurel')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Delaware', 'Dover', 'DE', 'Blue Hen Chicken', 'Peach Blossom')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Florida', 'Tallahassee', 'FL', 'Mockingbird (Northern)', 'Orange Blossom')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Georgia', 'Atlanta', 'GA', 'Brown Thrasher', 'Cherokee Rose')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Hawaii', 'Honolulu', 'HI', 'Nene (Hawaiian Goose)', 'Pua Aloalo')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Idaho', 'Boise', 'ID', 'Mountain Bluebird', 'Syringa - Mock Orange')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Illinois', 'Springfield', 'IL', 'Cardinal (Northern)', 'Purple Violet')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Indiana', 'Indianapolis', 'IN', 'Cardinal (Northern)', 'Peony')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Iowa', 'Des Moines', 'IA', 'American Goldfinch', 'Wild Prairie Rose')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Kansas', 'Topeka', 'KS', 'Western Meadowlark', 'Sunflower')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Kentucky', 'Frankfort', 'KY', 'Cardinal (Northern)', 'Goldenrod')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Louisiana', 'Baton Rouge', 'LA', 'Brown Pelican', 'Magnolia')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Maine', 'Augusta', 'ME', 'Black-Capped Chickadee', 'White pine cone and tassel')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Maryland', 'Annapolis', 'MD', 'Baltimore Oriole', 'Black-eyed Susan')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Massachusetts', 'Boston', 'MA', 'Black-Capped Chickadee', 'Trailing-Arbutus')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Michigan', 'Lansing', 'MI', 'American Robin', 'Apple Blossom')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Minnesota', 'St. Paul', 'MN', 'Common Loon', 'Pink and White Ladys-slipper')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Mississippi', 'Jackson', 'MS', 'Mockingbird (Northern)', 'Magnolia')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Missouri', 'Jefferson City', 'MO', 'Eastern Bluebird', 'Hawthorn')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Montana', 'Helena', 'MT', 'Western Meadowlark', 'Bitterroot')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Nebraska', 'Lincoln', 'NE', 'Western Meadowlark', 'Goldenrod')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Nevada', 'Carson City', 'NV', 'Mountain Bluebird', 'Sagebrush')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('New Hampshire', 'Concord', 'NH', 'Purple Finch', 'Purple Lilac')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('New Jersey', 'Trenton', 'NJ', 'American Goldfinch', 'Violet')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('New Mexico', 'Santa Fe', 'NM', 'Roadrunner (Greater)', 'Yucca flower')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('New York', 'Albany', 'NY', 'Eastern Bluebird', 'Rose')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('North Carolina', 'Raleigh', 'NC', 'Cardinal (Northern)', 'American Dogwood')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('North Dakota', 'Bismarck', 'ND', 'Western Meadowlark', 'Wild Prairie Rose')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Ohio', ' Columbus', 'OH', 'Cardinal (Northern)', 'Scarlet Carnation')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Oklahoma', ' Oklahoma City', 'OK', 'Scissor-Tailed Flycatcher', 'Mistletoe')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Oregon', ' Salem', 'OR', 'Western Meadowlark', 'Oregon Grape')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Pennsylvania', ' Harrisburg', 'PA', 'Ruffed Grouse', 'Mountain Laurel')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Rhode Island', ' Providence', 'RI', 'Rhode Island Red', 'Violet')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('South Carolina', ' Columbia', 'SC', 'Carolina Wren', 'Yellow Jessamine')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('South Dakota', ' Pierre', 'SD', 'Ring-Necked Pheasant', 'Pasque Flower')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Tennessee', ' Nashville', 'TN', 'Mockingbird (Northern)', 'Iris')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Texas', ' Austin', 'TX', 'Mockingbird (Northern)', 'Bluebonnet')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Utah', ' Salt Lake City', 'UT', 'California Gull', 'Sego Lily')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Vermont', ' Montpelier', 'VT', 'Hermit Thrush', 'Red Clover')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Virginia', ' Richmond', 'VA', 'Cardinal (Northern)', 'American Dogwood')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Washington', ' Olympia', 'WA', 'American Goldfinch', 'Coast Rhododendron')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('West Virginia', ' Charleston', 'WV', 'Cardinal (Northern)', 'Rhododendron')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Wisconsin', ' Madison', 'WI', 'American Robin', 'Wood Violet')
INSERT INTO dbo.colbert_stateFacts (state_name, state_capital, state_code, state_bird, state_flower) VALUES ('Wyoming', ' Cheyenne', 'WY ', 'Western Meadowlark', 'Indian Paintbrush')