Thom Pantazi


SQLServerCentral Article

Deleting Child Data Based Upon Criteria in the Parent Table

New Author! Thom's first article discusses the difficulties you encounter when your database doesn't support cascading deletes (or you've opted not to use it) and you need to delete data in a child table based upon a value in the parent table. Not exactly your run of the mill delete query. Take a look and please rate/comment the article!

You rated this post out of 5. Change rating

2003-06-24

5,295 reads

Blogs

Accept the no and move on

By

Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....

Don’t Fight with AI

By

I was recently trying to handle a simple task with a few AI tools...

Narrow Task Decomposition in AI Pipeline Agents

By

A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...

Read the latest Blogs

Forums

jdbc auth failing to sql from sap's cloud middleware CPI

By stan

hi , our business partner is asking s4 sap api's for receivable info and...

Searching for my own posts

By pietlinden

I have a really stupid question... Is there an easy way to search for...

How to Work with On-Premises AI Models to Generate T-SQL Code

By Daniel Calbimonte

Comments posted to this topic are about the item How to Work with On-Premises...

Visit the forum

Question of the Day

Escaping Strings

The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?

See possible answers