Delete a category and posts

Topics: Business Logic Layer
Mar 14, 2012 at 2:51 PM
Edited Mar 14, 2012 at 3:27 PM

How do I delete a specific category and all associated posts?

or could you provide me a MS SQL query to achieve this?

(MSSQL server 2005 shared godaddy host)


Mar 15, 2012 at 11:35 AM

There's 3 relevant tables:

  1. be_Categories
  2. be_Posts
  3. be_PostCategory (the linkage between be_Categories and be_Posts)