/* 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
VB学习数据库开发必看的经典实例源码
需积分: 50 172 浏览量
2017-12-03
21:10:15
上传
评论 4
收藏 3.07MB ZIP 举报
VB学习数据库开发必看的经典实例源码 （625个子文件） 
ODBC API Declarations.bas 63KB RegistryInformation.bas 4KB Readini.bas 2KB Readini.bas 2KB BMain.bas 2KB BMain.bas 2KB BMain.bas 2KB BMain.bas 2KB READINI.BAS 2KB Attach.bas 469B PicLoad.bas 364B Module1.bas 228B ReadINI.bas 144B SECURED.BAS 84B CDBExplorer.cls 18KB CDBExplorer.cls 18KB CDBExplorer.cls 17KB CDBExplorer.cls 15KB ExeExpenseDetail.cls 11KB ExpenseDetail.cls 11KB ExpenseDetail.cls 11KB ExpenseDetail.cls 11KB ExpDetailParam.cls 10KB HT202.cls 8KB HT206.cls 8KB HT204.cls 8KB HT203.cls 7KB HT205.cls 6KB HT201.cls 6KB cAuthor.cls 5KB cAuthor.cls 4KB clsInvoice.cls 4KB cAuthor.cls 4KB clsVendor.cls 3KB clsBackupTable.cls 2KB TableData.cls 1KB clsUtility.cls 756B clsUtility.cls 756B clsUtility.cls 756B clsUtility.cls 692B clsUtility.cls 656B clsUtility.cls 656B clsUtility.cls 656B ctlExpenseDetail.ctl 19KB BoundCombo.ctl 11KB ctlAddress.ctl 7KB EnhancedTimer.ctl 4KB VENDORS.DAT 367B INVOICES.DAT 289B DataReport1.DCA 48KB DataReport1.DCA 47KB drBasic.DCA 46KB DataReport1.DCA 46KB DataEnvironment1.DCA 4KB DataEnvironment1.DCA 4KB DataEnvironment1.DCA 4KB DataEnvironment1.DCA 4KB ActiveX.dll 25KB MiddleTier.dll 18KB MiddleTier.dll 17KB MiddleTier.dll 16KB
TempRpt.doc 21KB DataReport1.Dsr 13KB DataReport1.Dsr 13KB drBasic.Dsr 7KB DataReport1.Dsr 5KB DataEnvironment1.Dsr 3KB DataEnvironment1.Dsr 3KB DataEnvironment1.Dsr 2KB DataEnvironment1.Dsr 2KB DataReport1.dsx 31B DataReport1.dsx 31B drBasic.dsx 31B DataReport1.dsx 31B RepeaterTestControl.exp 1KB ExpDetailControl.exp 1KB BoundComboControl.exp 1KB BoundComboControl.exp 1KB EnhancedTimer.exp 1KB MiddleTier.exp 1KB MiddleTier.exp 1KB MiddleTier.exp 1KB ActiveX.exp 1024B frmPermissions.frm 19KB frmMain.frm 18KB frmMain.frm 18KB GetInfo.frm 17KB Addfield.frm 17KB frmMain.frm 17KB newtable.frm 16KB frmAuthors.frm 16KB Transact.frm 15KB frmMain.frm 15KB SAVE.FRM 14KB RPTWRITE.FRM 13KB frmWidgetOrders.frm 13KB frmWidgetOrders1111.frm 13KB ParameterQuery.frm 13KB TextImp.frm 13KB HT206.frm 12KB共 625 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
