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,293 reads

Blogs

AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared

By

Both SQL Server and PostgreSQL are moving fast into AI territory — and if...

Monday Monitor Tips: AI Alert Analysis

By

We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...

From SQL Saturday to Day of Data

By

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

Read the latest Blogs

Forums

Install SQL Scripts via GUI Wizard

By Jörg

Hallo all! My problem is this: I have quite a bunch of TSQL scripts...

Would You Retire Rather Than ...

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Would You Retire Rather Than...

Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For

By vgupta

Comments posted to this topic are about the item Vector Search in SQL Server...

Visit the forum

Question of the Day

Converting Money

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;

See possible answers