DELETE | TRUNCATE | SQL SERVER | TUTORIAL XIII

Veröffentlicht am: 10 Oktober 2020
auf dem Kanal: Freshlyne Nerd

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.
-------------------------------------------------------------------------------------

Auf dieser Seite können Sie das Online-Video DELETE | TRUNCATE | SQL SERVER | TUTORIAL XIII mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Freshlyne Nerd 10 Oktober 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 8 Mal angesehen und es wurde von 3 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

5,147

474