Insert

INSERT creates new documents in a schema. The schema must already exist. Documents in a schema do not need to have the same fields.

Inserts a single document.

INSERT INTO WordList:Language (Id, Name)
VALUES (10, 'Italian')

Inserts several documents. Repeat as many value sets as you like.

INSERT INTO WordList:Language (Id, Name)
VALUES (11, 'Dutch'), (12, 'Finnish'), (13, 'Latin')

Values can be expressions.

INSERT INTO WordList:Language (Id, Name, Code)
VALUES (14, 'Swedish', Sha1('Swedish') + '-' + Guid())

Each document lists its own fields, so the fields can vary from document to document.

INSERT INTO WordList:Language
(Id: 15, Name: 'Polish'),
(Id: 16, Name: 'Czech', Code: Guid())

Inserts the results of a query.

INSERT INTO WordList:Translation (SourceWord, SourceLanguage, TargetWord, TargetLanguage)
SELECT
    sw.Text as SourceWord,
    sl.Name as SourceLanguage,
    tw.Text as TargetWord,
    tl.Name as TargetLanguage
FROM
    WordList:Word as sw
INNER JOIN WordList:Language as sl
    ON sl.Id = sw.LanguageId
INNER JOIN WordList:Synonym as S
    ON S.SourceWordId = sw.Id
INNER JOIN WordList:Word as tw
    ON tw.Id = S.TargetWordId
INNER JOIN WordList:Language as tl
    ON tl.Id = tw.LanguageId
WHERE
    sw.Text = 'Cat'

• Select Into
• Update