DBI202Xuất hiện trong 1 đề thi
Choose the incorrect statement about DELETE and TRUNCATE in SQL Server.
Các lựa chọn
ADELETE is used for unconditional removal of data records from Tables; TRUNCATE is used for conditional removal of data records from Tables.
BDELETE is a DML command and the operations are logged, whereas TRUNCATE is a DDL command and the operations are not logged.
CDELETE removes records and records each deletion in the transaction log whereas TRUNCATE deallocates pages and records each deallocation in the transaction log.
DTRUNCATE is generally considered quicker as it makes less use of the transaction log.