Urgent: Get the missing column name

Are the fields unique in there respective columns?

Try this:

Edit

Sounds like you need a full outer join, in a function that returns a table wherethe full outer join finds nulls.  Maybe one for each table.  Then that could be the input for a transaction, or another stored procedure to uptadte the tables as needed.

hi

i recommend the following

dim dt1 as new datattable=get data from course in db1
dim dt2 as new datattable=get data from course in db2

then write a for loop to compare the columns name
ex: for i as integer=0 to dt1. Columns.Count -1 ...
and then u can know what is the missing
and base on that create a sql statement to do the necessary modification and execute it

The problem is that i cannot do a sql query because only the target datatable is from sql and the source datatable is from salesforce.Iam doing an import of data from salesforce and export it to sqlserver.

I have done coding to import the data from salesforce and export it to sqlserver.But say if they have added a custom field in the salesforce  and so i have to a comparison between datatables and find the missing column and then add that column to the sql server table.

i need a logic to compare two datatables for column names and then check whether there are any columns missing and then add that column to the target table in sql server.

Thanks Codecruiser the code worked like a charm.I am able to identify the missing column and will proceed to do the coding for alter table.