Home Forums Article Discussions Article Discussions by Author Discuss content posted by Edward Polley Hidden Tricks To SQL Server Table Cleanup RE: Hidden Tricks To SQL Server Table Cleanup
Rafal Ziolkowski
SSC Rookie
Points: 41
More actions
September 4, 2015 at 2:14 am
#1824566
divyesh.khimasia 4679 (9/4/2015)Cant we use TRUNCATE?
divyesh.khimasia 4679 (9/4/2015)
No we can't. You cannot specify WHERE clause in TRUNCATE, therefore you cannot specify which rows you want to remove - it just removes all of them.