Transact-SQL (T-SQL) Guide

📌 Introduction

Transact-SQL (T-SQL) is Microsoft’s extension of SQL (Structured Query Language).
It is mainly used in Microsoft SQL Server to define, manipulate, query, and control data in relational databases.

SQL commands are divided into the following categories:

1. DDL (Data Definition Language) – Defines and manages database structure.
2. DML (Data Manipulation Language) – Manages and manipulates data inside tables.
3. DQL (Data Query Language) – Queries and retrieves data.
4. TCL (Transaction Control Language) – Manages transactions and ensures data consistency.

---

📂 Contents

TRANSACT SQL

• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• DQL (Data Query Language)
• TCL (Transaction Control Language)

Function

• Scalar Function - Scalar Function - Multi-statement

---

📝 Quick Summary

Transact SQL

• DDL → Create, alter, drop, and truncate database objects.
• DML → Insert, update, delete, and merge data.
• DQL → Select and query data.
• TCL → Commit, rollback, and manage transactions.

Function

---

🚀 Usage

Clone this repository and open each .md file for detailed explanations with SQL code examples.

git clone https://github.com/your-username/tsql-guide.git
cd tsql-guide