Progress
SQL-92
Guide and Reference
INSERT Statement
Inserts new rows into the specified table or view that will contain either the explicitly specified values or the values returned by the query expression.
SYNTAX
EXAMPLES
NOTES
- If the optional list of column names is specified, then only the values for those columns are required. The rest of the columns of the inserted row will contain NULL values, provided that the table definition allows NULL values and there is no DEFAULT clause for the columns. If a DEFAULT clause is specified for a column and the column name is not present in the optional column list, then the column is given the default value.
- If the optional list is not specified, then all the column values must be either explicitly specified or returned by the query expression. The order of the values should be the same as the order in which the columns are declared in the declaration of the table or view.
- The VALUES ( ... ) form for specifying the column values inserts one row into the table. The query expression form inserts all the rows from the query results.
- If the table contains a foreign key and there is no corresponding primary key that matches the values of the foreign key in the record being inserted, the insert operation is rejected.
AUTHORIZATION
Must have DBA privilege, ownership of the table, INSERT privilege on the table, or SELECT privilege on all the tables or views referred to in the query_expression, if a query_expression is specified.
SQL COMPLIANCE
SQL-92, ODBC Core SQL grammar
ENVIRONMENT
Embedded SQL, interactive SQL, ODBC applications, JDBC applications
RELATED STATEMENTS
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |