sampleupgradescript.txt

来自「软件用于升级SQL数据库」· 文本 代码 · 共 16 行

'
' 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