Delete vs Truncate in SQL with examples #shorts #coding #sql #sqlqueries #sqlserver

preview_player
Показать описание
Delete vs Truncate in SQL with examples #shorts #coding #sql #sqlqueries #sqlserver #programming #youtubeshorts
Рекомендации по теме
Комментарии
Автор

Hi bro who said the truncated data can't rollback Truncated data also can rollback if the transaction is in begintran ... Deleted and truncated both can rollback ...Try once and let them know in next video ... Thankyou !

harineralla
Автор

Thank you 🎉. Truncate is faster than delete. But doesnt allow rollback.

matt_vid
Автор

DELETE
TRUNCATE
DROP

Are very important in SQL

ChenemiAbraham
Автор

Could you please share the database for practice...?

souvikdas
Автор

One more difference -delete does not resets the I'd but truncate resets I'd

RS-qwrd