Insert, Update, and Delete statements
- Last Updated: June 5, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- Microsoft SQL Server 6.0
- Documentation
The SQL Server driver supports returning parameter metadata for the following forms of Insert, Update, and Delete statements:
-
INSERT INTO foo VALUES (?, ?, ?) -
INSERT INTO foo (col1, col2, col3) VALUES (?, ?, ?) -
UPDATE foo SET col1=?, col2=?, col3=? WHERE col1operator? [{AND | OR}col2operator?] DELETE FROM foo WHERE col1 operator ?
where operator is any of the following SQL operators: =, <, >, <=, >=, and <>.