ODBC guide

INSERT single row

Inserts a single row using ZappySys query syntax. You can optionally use WITH(DatasetId='...', ProjectId='...', Output='*').

INSERT INTO MyBQTable1(SomeBQCol1, SomeBQCol2) VALUES(1,'AAA')
--WITH(DatasetId='TestDataset',Output='*')
--WITH(DatasetId='TestDataset',ProjectId='MyProjectId',Output='*')