Wednesday , October 17 2018

Tag Archives: DML

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-5bc701b755357462091192/]    

Read More »

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 records in a table. These are basic operations we perform on data such …

Read More »