... the terms "myDB1" with the first database name and "myDB2" with the name of the second database to compare to:
-- columns in old database but not in new
SELECT t1.* FROM [myDB1].[INFORMATION_SCHEMA].[COLUMNS] ...
... perform formatting to extract the minimum data here (eg. datetime into date, etc)
*
FROM
[pretendDatabase].[pretendSchema].[pretendTable] t0
WHERE
[pretendField]='elephantastic'
-- ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.