sampleupgradescript.txt

软件用于升级SQL数据库

'
' Sample Database Upgrade Script for an Access Database
'

CREATEFIELD SampleTable FieldKey Text 255
CREATEFIELD SampleTable FieldBoolean BOOLEAN
CREATEFIELD SampleTable FieldInteger INT
CREATEFIELD SampleTable FieldMemo MEMO
DELETEFIELD SampleTable FieldName

CREATEINDEX SampleTable FieldKey FieldKey

BEGINSQL IF NOT sELECT TOP 1 FieldKey FROM SampleTable WHERE FieldKey = '10'
	INSERT INTO SampleTable (FieldKey, FieldMemo) VALUES ('10', 'xxx')
ENDSQL