Re: How to Swap Two Tables?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 24 Oct 2003 00:59:49 GMT
Message-ID: <9Q_lb.3878$n95.2249@news01.roc.ny>

"RK" <rekaben_at_yahoo.com> wrote in message news:239f1935.0310231506.181e4b9c_at_posting.google.com...

> "nobody" <nobody_at_nowhere.com> wrote in message news:<7mUlb.253604$ko%.218644_at_news04.bloor.is.net.cable.rogers.com>...

> > tables t1 t2
> > rename t1 to t3;
> > rename t2 to t1;
> > rename t3 to t2;
> >
> > "RK" <rekaben_at_yahoo.com> wrote in message
> > news:239f1935.0310230807.5a9ccbc1_at_posting.google.com...
> > > Assuming space if not a problem, how can I exchange two table content
> > > (two table in same definition and structure) using SQL?
> > >
> > > RK

>
> Sorry. Maybe my first post question was unclear enough.
>
> I have two big tables. I want to compare the two table content to see
> if they are identical. If they are not, then I should exchange their
> content.
>
> Please tell me how I can do these two steps using SQL. And for the
> second step, if I am not allowed to create a temp table, how can I do
> it?
>
> Thanks.
>
> RK

This post is as unclear as the original post.

exchange means .. you want to put tableB's content into tableA and tableA's content into tableB. Same as swap!

Now I have a feeling that you want to sync tableA from the contents of tableB. i.e. At the end of it all you want to make tableA's content look exactly like tableB's content?

Does that reflect correctly what you wish to achieve?

Anurag Received on Thu Oct 23 2003 - 19:59:49 CDT