Скачать или смотреть DELETE vs TRUNCATE | DELETE Command | TRUNCATE Command |

DELETE vs TRUNCATE | DELETE Command | TRUNCATE Command | #TechPointFundamentals

Agenda:
---------
Q01. What is the difference between DELETE and TRUNCATE in SQL?
Q02. Is it true that DELETE can be rolled back, but TRUNCATE can’t be rolled back?
Q03. Is it true that DELETE can be restored back, but TRUNCATE can’t be restored back?
Q04. Is it true that TRUNCATE TABLE is non-logged?
Q05. Can you recover the deleted records from the Table?
Q06. What is LSN (Log Sequence Numbers) in SQL?
Q07. What is DELETED Table in SQL?

Difference:
-----------
1. DELETE is the DML command and TRUNCATE is the DDL command.
2. DELETE deletes records one by one, whereas TRUNCATE de-allocates pages at one go.
3. TRUNCATE resets the IDENTITY back to the SEED while DELETE does not.
4. You require delete permission on a table to use this. You require Alter table permissions to truncate a table.
5. You can use the Delete statement with the indexed views, but TRUNCATE cannot be used.
6. DELETE fires TRIGGERS but TRUNCATE does not.
7. Truncate is faster compared to delete as it makes less use of the transaction log.
8. You cannot specify a WHERE clause in a TRUNCATE TABLE statement while you can use it with DELETE.
9. Truncate is not possible when a table is referenced by a Foreign Key or tables are used in replication or with indexed views.


Subscribe to our YouTube Channel:    / @techpointfundamentals  
Visit our Website for more Articles: https://www.techpointfunda.com

Recommended Videos Playlists:
============================================================
SQL Videos Playlist: https://www.youtube.com/embed/videose...
C# Interview Questions and Answers Videos Playlist: https://www.youtube.com/embed/videose...
Visual Studio Tips and Tricks Videos Playlist: https://www.youtube.com/embed/videose...
Interview Questions and Answers Videos Playlist: https://www.youtube.com/embed/videose...
C# Videos Playlist: https://www.youtube.com/embed/videose...
C# 8 Videos Playlist: https://www.youtube.com/embed/videose...


Recommended SQL Videos:
============================================================
SubQuery vs CoRelated SubQuery:    • SubQuery vs Co-Related SubQuery | SubQuery...  
UNION vs UNION ALL video:    • UNION vs UNION ALL | UNION OPERATOR | UNIO...  
IN vs NOT IN Clause video:    • IN vs NOT IN Operator | IN Operator | NOT ...  
CROSS JOIN vs FULL JOIN video:    • CROSS JOIN vs FULL JOIN | FULL JOIN vs CRO...  
ON Clause vs WHERE clause for JOINS video:    • ON Clause vs WHERE clause for JOINS | INNE...  
INNER JOIN vs LEFT JOIN with WHERE statement video:    • INNER JOIN vs LEFT OUTER JOIN | INNER JOIN...  


Recommended C# Interview Questions Videos:
============================================================
Sealed Method Interview Questions and Answers videos:    • Sealed Method Interview Questions and Answ...  
Sealed Class Interview QA Video:    • Sealed Class Interview Questions and Answe...  
Static Class Interview QA Video:    • Static Class Interview Questions and Answe...  
Abstract Class vs Interface Video:    • Abstract Class Vs Interface C# 8 | Differe...  

Recommended C# Videos:
============================================================
Shadowing or Method Hiding video:    • Shadowing in C# | Method Hiding in C# | Te...  
Virtual Methods and Method Overriding video:    • Virtual Methods in C# | Method Overriding ...  
Abstract Class and Methods video:    • Abstract Class C# | Abstract Method C# | T...  
Sealed Class Video:    • Sealed Class and Sealed Methods in C# | Te...  
Static Class Video:    • Static Class, Static Constructor and Stati...  
Sealed Interface Method Video:    • Interface Member Modifiers with live Examp...  
Virtual Interface Method Video:    • Interface Virtual Members in C# 8 | Virtua...  
Partial Classes Video:    • Partial Classes with Real Examples in C# |...  


Follow Us on Social Media Platforms:
============================================================
Follow us on Facebook:   / techpointfundamentalsofficials  
Visit our Facebook Page:   / techpointfundamentals  
Join our Facebook Interview Questions and Answers Group:   / interviewpreparationbytechpoint  
Join our Facebook IT Group:   / itechfunda  

Follow us on LinkedIn:   / techpointfundamentals  
Join our LinkedIn Interview Questions and Answers Group:   / 13906177  

Follow us on Telegram: https://t.me/TechPointFundamantals
Join our Telegram Interview Questions and Answers Group: https://t.me/InterviewQuestionsAndAns...

Follow us on VK: https://vk.com/techpointfundamentals
Join our VK Interview Questions and Answers Community: https://vk.com/interviewquestionsanda...

Follow us on Twitter:   / techpointfunda  
Follow us on Pinterest:   / techpointfundamentals  
Follow us on Instagram:   / techpointfundamentals  
Follow us on Mix: https://mix.com/techpointfundmentals
Follow us on Tumblr:   / techpointfundamentals