Posted by Amit on 12/04/07 14:11

Hi,
I am able to retrive the uncommon columns from two similar tables, but the problem is i require a query, which can help me to find out which columns are added separately.
Another query which can say which columns are deleted.
And the last one can say which column has changed .

Plzz.. help me soon.

From http://www.developmentnow.com/g/95_2006_4_0_0_742685/SELECT---FROM--multiple-tables--WHERE--field-in-those-tables-have-the-same-paricular-value-.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

• Next in forum: Re: Using updatable views when moving tables from one DB to another?
• Prev in forum: Re: multi column sub select equivalent for sql server 2005
• Thread view: RE: SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_value" ?

[Reply to this message]