DML Archive

SQL Server: 07 – INSERT and SELECT Statement

  INSERT Statement Syntax: INSERT INTO TABLE_NAME (column1, column2, column3,…columnN)] VALUES (value1, value2, value3,…valueN); SELECT Statement Syntax: SELECT column1, column2, columnN FROM table_name;   [crayon-5b4e736897c80313763060/]    

SQL Server: 04 – T-SQL Statemetns Categories

  The four main categories of SQL statements are as follows: DML (Data Manipulation Language) 2. DDL (Data Definition Language) 3. DCL (Data Control Language) 4. TCL (Transaction Control Language) DML (Data Manipulation Language) DML statements affect