what this query do when delete ?

Question

I work on SQL server only I have delete statement delete data from
table trade code
but I don't know when this statement delete Executed

DELETE FT

 FROM Parts.Nop_Part pt 
 INNER JOIN Parts.Nop_PartsFamilyAttribute fm ON pt.PartsFamilyID=fm.PartFamilyID AND fm.[Key]=20281007 
 INNER JOIN #Pls pl ON pl.ZPLID=fm.Value
 INNER JOIN Parts.TradeCodes FT ON pt.PartID=ft.PartID AND FT.PartLevel=0
 INNER JOIN #PLNewData TN ON TN.PartID = FT.PartID AND TN.CodeTypeID = FT.CodeTypeID
 WHERE 
 TN.Code <> FT.Code 

I know that statement delete from table trade code but I need small case when this delete from table trade code
done

Answer 1

It deletes the rows from TradesCode table that satisfy the conditions, which are expressed in SQL and can be interpreted in this manner:

• The PartLevel is zero
• There is a corresponding row (or rows) in Nop_Parts according to PartID
• There is a corresponding row (or rows) in Nop_PartsFamilyAttribute according to PartFamilyID, excepting rows that have Key=20281007 and excepting rows that are enumerated in #Pls by Value
• There is a corresponding row (or rows) in #PLNewData according to PartID and CodeTypeID, which has a different Code,

or something like this. Re-check the conditions that appear in ON and WHERE, and see the algorithm used to fill #Pls and #PLNewData.

Answer 2

The DELETE statement deletes the rows from the table Parts.TradeCodes.

Answer 3

thank you for reply
I know it delete from table parts.tradecodes

this delete will happen when

Answer 4

Hi @ahmed salah ,

DELETE removes one or more rows from a table or view in SQL Server.
When executing the delete statement above, first execute the FROM and WHERE clauses, select the rows to be deleted, and then execute the DELETE clause to delete these rows.

Regards
Echo

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues November--What can I do if my transaction log is full?
Hot issues November--How to convert Profiler trace into a SQL Server table

Answer 5

according to statement above when delete from table parts.tradecodes
so what must exist on table pl and plnewdata to delete happen