MSHostFileClient SQL syntax
SELECT Statements
1. SELECT <Column Collection> FROM Filename WHERE <Where Clause>
2. SELECT <Column Collection> FROM Filename AS <AssemblyName.SchemaName> WHERE <Where Clause>
Details of Column Collection parsing and Where Clause parsing are described later in this document.
INSERT Statements
1. INSERT INTO Filename VALUES ( <Values> )
2. INSERT INTO Filename AS <AssemblyName.SchemaName> VALUES ( <Values> )
3. INSERT INTO Filename ( <Column Collection> ) VALUES ( <Values> )
4. INSERT INTO Filename AS <AssemblyName.SchemaName> ( <Column Collection> ) VALUES ( <Values> )
Details of Column Collection parsing and Where Clause parsing are described later in this document.
UPDATE Statements
1. UPDATE Filename SET ( <Values>)
2. UPDATE Filename SET ( <Values>) WHERE <Where Clause>
3. UPDATE Filename AS <AssemblyName.SchemaName> SET ( <Values>)
4. UPDATE Filename AS <AssemblyName.SchemaName> SET ( <Values>) WHERE <Where Clause>
5. UPDATE Filename SET (<Column Collection>) ( <Values>)
6. UPDATE Filename SET (<Column Collection>) ( <Values>) WHERE <Where Clause>
Details of Column Collection parsing and Where Clause parsing are described later in this document.
DELETE Statements
1. DELETE FROM Filename
2. DELETE FROM Filename WHERE <Where Clause>
3. DELETE FROM Filename AS <AssemblyName.SchemaName>
4. DELETE FROM Filename AS <AssemblyName.SchemaName> WHERE <Where Clause>
e.g.
1. WHERE KEY (KEY_COL) = ‘1290’
2. WHERE KEY (KEY_COL) EQUALS ‘1290’
3. WHERE KEY (KEY_COL) BETWEEN 1290 AND 1390
4. WHERE KEY (KEY_COL) BETWEEN 1290 INCLUSIVE AND 1390 EXCLUSIVE
5. WHERE POSITION = 101
6. WHERE POSITION EQUALS 101
7. WHERE POSITION BETWEEN 101 AND 201
8. WHERE POSITION BETWEEN 101 EXCLUSIVE AND 201 INCLUSIVE
e.g. use of where clause :
UPDATE Filename SET (OUT1_INTEGER) (7) WHERE <Applicable where clause from above>
