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 col1 operator  ? [{AND | OR} col2  operator ?]
  • DELETE FROM foo WHERE col1 operator ?

where operator is any of the following SQL operators: =, <, >, <=, >=, and <>.