News

Later, in the Implementation Guide you can read about use of INSERT, UPDATE and DELETE queries ... It depends upon the problem that the query is being designed to resolve.
INSERT inserts rows into a DBMS table. UPDATE updates the data values in a DBMS table. Because the SQL procedure is based on the Structured Query Language, it works somewhat differently than some SAS ...
The following lines of code use JDBC to add a new record to the Player table of the HSQLDB database: String insertQuery = "INSERT INTO PLAYER VALUES (1,'McKenzie','password')"; Statement stmt = ...