|
Home > Archive > MS SQL Server Tools > March 2006 > Query
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
| |
| Erland Sommarskog 2006-03-23, 8:34 pm |
| 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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/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:Xns979040CD7705
Yazorman@127.0.0.1...
> MC (webmaster@ozoptics.com) writes:
2[color=darkred]
>
> 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/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
| |
| JP Bless 2006-03-27, 1:32 pm |
| 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...
> 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:Xns979040CD7705
Yazorman@127.0.0.1...
from[color=darkred]
> 2
same[color=darkred]
B"[color=darkred]
http://www.microsoft.com/technet/pr...oads/books.mspx[color=darkred]
>
>
|
|
|
|
|