Difference Between Delete and Truncate

[@reggaemylitis1968]

Thanks very much. You make it so simple. Appreciated.

[@RamGuptaoracle]

Thank you so much for you feedback +Reggaemylitis , Please stay tune with the channel by Subscribe. Keep giving feedback :)
For subscribe
ruclips.net/user/ramguptaoracle

[@santoshkundahre855]

Very nice and Good Explanation,
Please clear me my Daught....
I Am using SQL Server 2014 Management Studio
If we use following Sequence of statement then what will be the result
Begin transaction
Delete from Table_Name;
Rollback;
In Delete and Truncate, Deleted and Truncate data can be rollback.

[@RamGuptaoracle]

Thank you so much for your feedback Santosh+ , and sorry to say as I don't have experience on SQL Server database on any version. I am not into position reply answer of this question.

[@siddhartharao8490]

Good Video and Nice Explanation..

[@RamGuptaoracle]

Thanks For feedback Siddhartha

[@a2zentertainmemt]

Hey nice explanation .... :)

[@SaurabhSingh-dd9yk]

one small correction, with truncate table clause is used not from as it's a ddl command.

[@lmca2010]

good videos :)
ps consider referring that if a table is "pointed" by a child enabled FK , TRUNCATE is not allowed (even if there're no child records there) .

[@RamGuptaoracle]

+lmca2010 Thanks for your feedback Imca :)

[@abhi13456]

We can have triggers on truncate as well? You mentioned triggers will not fire on truncate.

[@jagadishm1472]

fine

[@sapphodawson8420]

TRUNCATE can be rollback :)