states.sql

《VB6数据库开发指南》所有的例程的源码

/* Create the table */

CREATE TABLE States
	(
		StateCode CHAR(2) NOT NULL
			CONSTRAINT apkStates PRIMARY KEY NONCLUSTERED,
		StateName VARCHAR(30) NOT NULL
	)
Go
CREATE UNIQUE CLUSTERED INDEX ucdxStates ON States ( StateName )
Go

/* Add Data */

INSERT INTO States ( StateCode, StateName ) VALUES ('AK','Alaska')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('AL','Alabama')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('AZ','Arizona')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('AR','Arkansas')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('CA','California')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('CO','Colorado')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('CT','Connecticut')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('DC','District of Columbia')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('DE','Delaware')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('FL','Florida')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('GA','Georgia')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('HI','Hawaii')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('IA','Iowa')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('ID','Idaho')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('IL','Illinois')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('IN','Indiana')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('KS','Kansas')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('KY','Kentucky')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('LA','Louisiana')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('MA','Massachusetts')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('MD','Maryland')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('ME','Maine')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('MI','Michigan')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('MN','Minnesota')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('MO','Missouri')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('MS','Mississippi')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('MT','Montana')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('NE','Nebraska')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('NV','Nevada')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('NH','New Hampshire')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('NJ','New Jersey')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('NM','New Mexico')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('NY','New York')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('NC','North Carolina')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('ND','North Dakota')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('OH','Ohio')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('OK','Oklahoma')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('OR','Oregon')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('PA','Pennsylvania')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('RI','Rhode Island')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('SC','South Carolina')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('SD','South Dakota')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('TN','Tennessee')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('TX','Texas')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('UT','Utah')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('VA','Virginia')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('VT','Vermont')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('WA','Washington')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('WI','Wisconsin')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('WV','West Virginia')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('WY','Wyoming')
Go
INSERT INTO States ( StateCode, StateName ) VALUES ('PR','Puerto Rico')
Go