Re: How to Swap Two Tables?

From: RK <rekaben_at_yahoo.com>
Date: 29 Oct 2003 07:56:38 -0800
Message-ID: <239f1935.0310290756.6c392348@posting.google.com>

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<9Q_lb.3878$n95.2249_at_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
>

Well, this newsgroup may have some virus. After I posted my first question, I was bombed by bulk-email-spam.

Now return to my questions. Let me ask them one by one --

Fist One:

With SQL, how can I compare two table content to see if they are identical or not? If not, can I show their difference using certain SQL commands and dump the output?

Thanks. Received on Wed Oct 29 2003 - 09:56:38 CST