Microsoft JDBC Driver - DML Statements

JDBC for SQL Server - Herong's Tutorial Examples

∟Microsoft JDBC Driver - DML Statements

This chapter provides tutorial notes on executing DDL statements with Microsoft JDBC Driver. Topics include inserting, updating and deleting data rows in existing tables.

"SELECT ... INTO" Statements

"INSERT INTO" Statements

"INSERT INTO" Statements with INDENTITY Columns

"UPDATE" Statements

"DELETE FROM" Statements

Takeaways:

DML (Data Manipulation Language) statements are used to select, insert, update, or delete data records in tables.
MS SQL Server supports a special SELECT statement with an INTO clause, combines SELECT, CREATE TABLE and INSERT operations in a single statement.
MS SQL Server has no issues supporting DML statements like SELECT, UPDATE, INSERT INTO and DELETE FROM.