17.How to Use ROLLBACK (UNDO) & TRUNCATE /DROP SQL SERVER in Telugu

Опубликовано: 16 Июнь 2026
на канале: Learners Page

2,660

One of the most popular Interview questions, Is it possible to Rollback Truncate operation? The answer is YES. Watch this video with out Skip.

@Learnerspage t.me/Learnerspage follow us on Telegram

https://t.me/Learnerspage

TCL (Transaction Control Language) :

ROLLBACK command
This command restores the database to last commited state. It is also used with SAVEPOINT command to jump to a savepoint in an ongoing transaction.

If we have used the UPDATE command to make some changes into the database, and realise that those changes were not required, then we can use the ROLLBACK command to rollback those changes, if they were not commited using the COMMIT command.

create table TrancateTest (ID int)
select *from TrancateTest

insert into TrancateTest (ID)
select 1
Union All
select 2
Union All
Select 3
go

begin Tran

drop table TrancateTest
go

select *from TrancateTest

Rollback Tran

go

How to change font size in sql server management studio? SQL in Telugu
   • 15.How to change font size in sql server m...

Delete vs Drop vs Truncate Sql Server in Telugu
   • 14.Delete vs Drop vs Truncate Sql Server i...

Merge Statement in SQL Telugu | How to Merge Statements in SQL
   • 13.Merge Statement in SQL Telugu | How to ...

Data Warehouse in Telugu

   • Data Warehouse in Telugu

ETL and SSIS :    • SSIS  in Telugu :SQL Server Integration Se...

Tableau in Telugu: Tableau Colors

   • 4.Tableau in Telugu: Tableau Colors

EXCEL IN TELUGU: FETCH DATA FROM SQL TO EXCEL

   • EXCEL  IN TELUGU:  IMPORT DATA  FROM SQL T...

BIGDATA in TELUGU

   • BIGDATA in TELUGU

Tableau in Telugu: Import data from Excel

   • 2.Tableau  in Telugu: Import data from Exc...

Pareto Chart Analysis Excel in Telugu

   • Pareto Chart Analysis Excel in Telugu