Define Truncate and Delete commands?
Submitted by: AdministratorTruncate:
► Truncate command is used to remove all rows of the column.
► The removed records are not recorded in the transaction log.
► It is the fast way to remove all the records from the table.
► The records once removed can't be rolled back.
► It can't activate trigger.
► It resets the identity of the column.
Delete:
Delete command removes records one at a time and logs into the transaction log.
It can be used with or without where clause.
The records can be rolled back.
It activates trigger.
It doesn't reset the identity of the column.
Submitted by: Administrator
► Truncate command is used to remove all rows of the column.
► The removed records are not recorded in the transaction log.
► It is the fast way to remove all the records from the table.
► The records once removed can't be rolled back.
► It can't activate trigger.
► It resets the identity of the column.
Delete:
Delete command removes records one at a time and logs into the transaction log.
It can be used with or without where clause.
The records can be rolled back.
It activates trigger.
It doesn't reset the identity of the column.
Submitted by: Administrator
Read Online SSRS Job Interview Questions And Answers
Top SSRS Questions
☺ | Explain the architecture of reporting services? |
☺ | What is RAID (Redundant Array of Inexpensive disks)? Explain its level? |
☺ | What are the ways to tune Reporting Services? |
☺ | Describe Reporting Lifecycle? |
☺ | What can SQL Server Reporting Services do? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |