TRUNCATE Tag Archives

Introduction to the Delete Statement

The DELETE statement is used to remove rows from a SQL Server data table. In this article we’ll explore how to use the DELETE statement. We discuss some best practices, limitations, and wrap-up with several examples. This is the fourth article in a series of articles. You can start at the beginning by reading Introduction to […]

SQL Truncate and Delete

In SQL Server there are a couple a ways you can delete rows from a table. You can use the TRUNCATE and DELETE command. Though the end result of both commands is the same, there are very important differences you should know about. Whats the Difference between Truncate and Delete? The TRUNCATE command is like a DELETE […]