与通常的INSERT语句的唯一区别是您添加了数据库(和架构)前缀.

Only difference from your usual INSERT statement is that you add database (and schema) prefix.

INSERT INTO [Database1].[schema_Name].[TableXYZ]
SELECT 
  Column1
, Column2
, Column3
....
, ColumnN 
FROM [Database2].[schema_Name].[TableXYZ]

-- example with your tbl_empaddress

INSERT INTO [Database1].[dbo].[tbl_empaddress]
SELECT empid, Address
FROM [Database2].[dbo].[tbl_empaddress]