/T-SQL

T-SQL Demos from scratch to advanced

Primary LanguagePLSQL

T-SQL

What is Transact-SQL?

  1. Structured Query Language (SQL)
  2. Developed by IBM in 1970s
  3. Adopted as a standard by ANSI and ISO standards bodies
  4. Widely used in industry

Microsoft’s implementation is Transact-SQL

  1. Referred to as T-SQL
  2. Query language for SQL Server and Azure SQL Database
  3. SQL is declarative, not procedural
  4. Describe what you want, don’t specify steps

SQL Statement Types

Data Manipulation Language (DML)

Statements for querying and modifying data:

  1. SELECT
  2. INSERT
  3. UPDATE
  4. DELETE

Data Definition Language (DDL)

Statements for defining database objects:

  1. CREATE
  2. ALTER
  3. DROP

Data Control Language (DCL)

Statements for assigning security permissions:

  1. GRANT
  2. REVOKE
  3. DENY