DELETE | TRUNCATE | SQL SERVER | TUTORIAL XIII
This SQL SERVER tutorial video, you will learn how to use DELETE AND TRUNCATE COMMAND of Sql Server.
DELETE is DML Command which is used for deleting the specific data. Also we can use it with Where Clause, Can rollback the changes.
TRUNCATE is DDL Command used to delete the entire data of the table. It can't be used with Where Clause, Can't rollback the changes.
Syntax :
//Truncate :
TRUNCATE TABLE tablename;
//Delete :
DELETE FROM tablename WHERE condition;
Later in the upcoming video all the SQL commands and concepts will be covered in detail.
This Freshlyne Nerd tutorial video on SQL Server explains all the basic to advance level concepts of SQL Server with examples
along with interview questions and assessments.
------------------------------------------------------------------------------------------------------------------------
Watch the previous lectures of :
UPDATE COMMAND | SQL SERVER | TUTORIAL XII :
• UPDATE COMMAND | SQL SERVER | TUTORIAL XII :
*IDENTITY COLUMN CONSTRAINT | SQL SERVER | TUTORIAL XI :
• IDENTITY COLUMN CONSTRAINT | SQL SERVER | ...
*CONSTRAINTS | CHECK | DEFAULT | PART - 3 | SQL SERVER TUTORIAL X :
• CONSTRAINTS | CHECK | DEFAULT | PART - 3 |...
*CONSTRAINTS | UNIQUE KEY | NOT NULL | PART - 2 | SQL SERVER TUTORIAL :
• CONSTRAINTS | UNIQUE KEY | NOT NULL | PART...
CONSTRAINTS IN SQL SERVER | PART 1 | SQL SERVER Tutorial for beginners 2020 :
• CONSTRAINTS | TYPES OF CONSTRAINTS | PRIMA...
*Order By and Top Clause in SQL Server | SQL SERVER Tutorial for beginners 2020 :
• Order By and Top Clause in SQL Server | SQ...
*How to Create New Table from an Existing Table in SQL | SQL SERVER Tutorial :
• How to Create New Table from an Existing T...
*How to use SQL WHERE CLAUSE | SQL SERVER Tutorial for beginners :
• How to use SQL WHERE CLAUSE | SQL SERVER T...
*How to use INSERT INTO command | SQL server tutorial for beginners 2020 :
• How to use INSERT INTO command | SQL serve...
*Table | Key points to create Table | Tricks rarely used in table creation :
• Table | Key points to create Table | Trick...
What is SQL ? | Types Of SQL Command | Creating Databases and Tables:
• What is SQL ? | Types Of SQL Command | Cr...
Introduction to Databases | Fundamental Concepts :
• SQL Server Lesson #1 - Introduction to Dat...
Subscribe to our Freshlyne Nerd YouTube Channel and
hit the bell icon to get video updates.
-----------------------------------------------------------------------------------
Instagram: https://www.instagram.com/freshlynene...
--------------------------------------------------------------------------------
Any question on the topic? Please share it in the comment section below and our experts will answer it to you.
Please write back to us at freshlynenerd@gmail.com for more information.
-------------------------------------------------------------------------------------
En esta página del sitio puede ver el video en línea DELETE | TRUNCATE | SQL SERVER | TUTORIAL XIII de Duración hora minuto segunda en buena calidad , que subió el usuario Freshlyne Nerd 10 octubre 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 8 veces y le gustó 3 a los espectadores. Disfruta viendo!
