Thursday, March 8, 2012

Compare Databases

Hi,
I have a field TestDescription in tableA in DatabaseA. The data in this field is coming from three different fields in three different fields in DatabaseB.
Is there a way to write a script to check if the length of this field TestDescription is greater than length of all those three fields in DatabaseB?
ThanksYes, write the code as if it was in differenent tables in the same database and then fully qualify the table name with the full-on [databaseName].[owner], etc, etc to do a cross database query.

No comments:

Post a Comment