SQL

RECORD

Connexion To Database

connect = Server.CreateObject("ADODB.Connection");
connect.Open ("ODBC Name","","");
connect.Close();
rs = Server.CreateObject("ADODB.Recordset");
rs.Open(sql,connect,3,3);

Record

rs.MoveFirst() . First Record
rs.MoveLast() : Last Record
rs.MovePrevious() : Previuos record
rs.MoveNext() : Next Record
rs.EOF : End Of File
!rs.EOF : Not End Of File
rs.RecordCount : Number of record

Record Value

rs.Fields("FieldName")

SQL INSERT

INSERT INTO TABLENAME (FIELDS1,FIELDS2,...) VALUES (VALUE1,VALUE2,...');

SQL UPDATE

UPDATE TABLENAME SET FIELDS1=VALUE1 , FIELDS2=VALUE2 [WHERE ... ]

SQL DELETE

DELETE FROM TABLENAME WHERE FIELDS1="+VALUE1;

VALUES TYPE

TEXTE,MEMO = 'VALUE1'
DATE = #VALUE1# VALUE1 = 01/08/2000

Recherche "Case sensitive" avec SQL

sql = "SELECT fullname FROM Contacts WHERE localite COLLATE SQL_Latin1_General_CP1_CS_AS = 'Anderlecht' ORDER BY id;"