Query

Can someone help me for a SQL query to delete all the transactions from 2
SQL table?
Here is what I want to do.
"Go thru all the transactions in both table A and B
If table A has a record, delete this record first, then delete the same
record info from B
If table A has no record reference, continue and delete the record in B"
and so on.
Thanks
MC (webmaster@.ozoptics.com) writes:
> Can someone help me for a SQL query to delete all the transactions from 2
> SQL table?
> Here is what I want to do.
> "Go thru all the transactions in both table A and B
> If table A has a record, delete this record first, then delete the same
> record info from B
> If table A has no record reference, continue and delete the record in B"
DELETE B
DELETE A
And most of all, don't delete row by row, delete all in one statement.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||My mistake,
Actually, I wanted to delete the records in both Table A and B, before Oct
4, 2004
MC
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns979040CD7705Yazorman@.127.0.0.1...[vbcol=seagreen]
> MC (webmaster@.ozoptics.com) writes:
2
> DELETE B
> DELETE A
> And most of all, don't delete row by row, delete all in one statement.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||DELETE TableA.*, TableA.DateField
FROM TableA WHERE TableA.DateField < 10/4/2004
"MC" <webmaster@.ozoptics.com> wrote in message
news:OLN%23fw0TGHA.1868@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> My mistake,
> Actually, I wanted to delete the records in both Table A and B, before Oct
> 4, 2004
> MC
> "Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
> news:Xns979040CD7705Yazorman@.127.0.0.1...
from[vbcol=seagreen]
> 2
same[vbcol=seagreen]
B"[vbcol=seagreen]
http://www.microsoft.com/technet/pro...ads/books.mspx
>
sql