SOAP(Simple Object Access Protocol) .
www.codecollege.NET
Sno | TRUNCATE | DELETE |
1 | TRUNCATE is faster | Comparitively slower. |
2 | Removes all rows from a table | Can remove specific rows with Where clause |
3 | Can not be Rolled back. | Can be. |
4 | Is DDL | Is DML Command. |
5 | Resets identity of the | Does not. |
6 | Removes the data by deallocating the data pages and | Removes one row at a time and records an entry in |
Sno | Primarykey | Unique key |
1 | Creates Clustered index. | Creates Non-Clustered index. |
2 | Null values are not allowed | Allows. |