비교4

Source: Dev.to

사용자 테이블을 비교하는 SQL 쿼리

-- First get the user IDs once (optional, for readability)
DECLARE @uid1 int, @uid2 int
SELECT @uid1 = uid FROM sysusers WHERE name = 'GLOBAL_COMET_US_1'
SELECT @uid2 = uid FROM sysusers WHERE name = 'GLOBAL_COMET_US_2'

SELECT 'ONLY_IN_US_1' AS location, t1.tabname
FROM   sysobjects t1
LEFT JOIN sysobjects t2 
       ON t1.tabname = t2.tabname
      AND t2.uid = @uid2
      AND t2.type = 'U'
WHERE  t1.uid = @uid1
  AND  t1.type = 'U'
  AND  t2.id IS NULL

UNION ALL

SELECT 'ONLY_IN_US_2' AS location, t2.tabname
FROM   sysobjects t2
LEFT JOIN sysobjects t1 
       ON t2.tabname = t1.tabname
      AND t1.uid = @uid1
      AND t1.type = 'U'
WHERE  t2.uid = @uid2
  AND  t2.type = 'U'
  AND  t1.id IS NULL

ORDER BY 1, 2