Posted by Hugo Kornelis on 12/04/07 20:47

On Tue, 04 Dec 2007 14:11:47 GMT, Amit wrote:

>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.

Hi Amit,


In order to properly help you, you must give me a better understanding
of your problem. The best way to do that is by posting
* CREATE TABLE statements for the table(s) involved in the problem,
including all constraints, properties, and indexes (though you may omit
irrelevant columns);
* INSERT statements with some well-chosen rows of sample data to
illustrate the problem; and
* expected results.

See www.aspfaq.com/5006 for more information.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Re: What is the purpose of the ROWGUIDCOL property?
• 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]