sql - 不同的数据库在注册表中标识

Question

我需要知道他们在做选择时来自哪个数据库，uni 使用 UNION，他们是 5 个具有相同字段的不同数据库

SELECT *, DB_NAME()[DATABASE] FROM SMKNEW.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'
UNION ALL SELECT *, DB_NAME()[DATABASE] FROM DH.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'
UNION ALL SELECT *, DB_NAME()[DATABASE] FROM FE.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'
UNION ALL SELECT *, DB_NAME()[DATABASE] FROM PSQ.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'
UNION ALL SELECT *, DB_NAME()[DATABASE] FROM RH.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'

我需要知道他们在做选择时来自哪个数据库，uni 使用 UNION，他们是 5 个具有相同字段的不同数据库

也试试这个..

我怎么知道注册表来自哪个数据库？

Answer 1

您已经知道查询中的数据库名称，那么为什么不像下面这样呢

SELECT *, 'SMKNEW' as [DATABASE] FROM SMKNEW.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'
UNION ALL SELECT *, 'DH' as [DATABASE] FROM DH.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'
UNION ALL SELECT *, 'FE' as [DATABASE] FROM FE.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'
UNION ALL SELECT *, 'PSQ' as [DATABASE] FROM PSQ.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'
UNION ALL SELECT *, 'RH' as [DATABASE] FROM RH.dbo.COLABORA WHERE CB_CODIGO LIKE '%11%'