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 […]
Continue reading
16
What is the Difference between Truncate and Delete in SQL Server?
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. The TRUNCATE command is like a DELETE command without the WHERE clause with much […]
Continue reading