Скачать или смотреть DIFFERENCE BETWEEN TRUNCATE AND DELETE statements in SQL Server 2016

Watch this tutorial to learn how to write Truncate and Delete statements in SQL Server 2016 and learn the differences.

Truncate is a Data Definition Language (DDL), and Delete is a Data Manipulation Language (DML)

Don't forget to check my videos on other DDLs and DMLs in SQL Server:

##Links to DDL Statements
How to CREATE Databases, Schemas, and Tables in SQL Server Management Studio using T-SQL
   • How to CREATE DATABASE, SCHEMA, AND TABLES...  

SQL Server DROP Statement
   • SQL Server DROP STATEMENT | Drop Schemas, ...  

ALTER statement in SQL Server
   • How to ADD, DROP AND MODIFY TABLE USING AL...  

A bonus video on How to import tables from Excel into SQL Server
   • How to IMPORT TABLES FROM EXCEL INTO SQL S...  

##Links to DML Statements
INSERT data into Tables in SQL Server 2016
   • How to INSERT DATA INTO tables in SQL Serv...  

Introduction to SELECT statement in SQL Server
   • Introduction to SELECT STATEMENT in SQL Se...  

How to UPDATE Table Records or Data in SQL Server | SQL Server Tutorials for Beginners
   • How to UPDATE TABLE RECORDS / DATA in SQL ...