Needs["DatabaseLink`"]

conn = OpenSQLConnection[ "demo"];

SQLCreateTable[conn, SQLTable["TEST"], {SQLColumn["COL1", "DataTypeName"->"INTEGER"], SQLColumn["COL2", "DataTypeName"->"DOUBLE"]}];

SQLInsert[conn, "TEST", {"COL1", "COL2"},  {10, 10.5}]

SQLSelect[conn, "TEST"]

SQLInsert[conn, "TEST", {"COL1", "COL2"}, {{10, 10.5},{20,55.1}}]

SQLSelect[conn, "TEST"]