T-SQL: Delete All Rows From a Table Except Top(N) Rows

I added the article which comes from a question that asked in MSDN forum. The problem is how to delete all rows from a table but remain the Top (N) rows, for example, remaining only the top (1000) rows. All Code samples in this article are downloadable from this   link . Please navigate to this link

Advertisements

T-SQL: Error Handling for CHECK Constraints

 

Happy New Year 2015 to all! 🙂

This is my first post in new year and wish I will be more active this year!
In the former article about CHECK constraints, we did not cover how to handle the errors when a CHECK constraint violates. In this article, we cover this important topic. It has worth to take a look at that article, if it needed. Please navigate to the article via this link.