Microsoft Access Database Development With VBA

SQL Keywords: VALUES

   

Description

The VALUES keyword is used to specify the value(s) used to create a new record into a table using SQL. The formula to follow is:

INSERT TableName VALUES(Column1, Column2, Column_n)

or:

INSERT INTO TableName VALUES(Column1, Column2, Column_n)

The VALUES keyword precedes the list of values that are passed in its parentheses.

     
 

Home Copyright © 2012-2013 FunctionX, Inc. Home