SQL Server Transact Basic to Expert - Truncate Query

SQL Server Transact Basic to Expert - Truncate Query

This blog shows how to use the Truncate statement to delete the records. Truncate statements works similar like delete but it has it own advantages as well..

Syntax:
Truncate Table tablename

Example:
Truncate table emptable