Thursday , October 17 2019

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;   CREATE DATABASE Test01 USE Test01 CREATE TABLE tblUser ( [ID] int NOT NULL, [Name] varchar(50) NOT NULL, [Email] varchar(50) NOT NULL, [Password] varchar(50) NOT NULL, [Age] …

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 »