how to compare two data tables having same column and contain some values according to column name using stored procedure in sql dbx?

[User 11950984]

Lets consider table 1 contain 30 column and table 2 is 30 column.i want to compare values one by one with respect to column name.eg.Table 1 column are A,B,C.. and Table 2 Column A,B,C....And values are xyz,abc,pqr and from table 2 xyz,jkl,pqr.Final result is Right,wrong,right likewise..

[Lost User]

Very interesting, do you have a question?

[Mycroft Holmes]

Assuming the tables have the same primary key then do an inner join on the PK and compare each field. Your question is ambiguous, do you want to compare each field in each record, the distinct of each column. try explaining it again in more detail and we may be more useful.

Never underestimate the power of human stupidity RAH

[ngoj]

I assume you are talking about C# client side comparing with DataTable object(s). It that is the case you should check this: www.dotnetperls.com/datatable-compare-rows