Share via

MSHostFileClient SQL syntax

  • Article

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>