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. |