You can achieved through Dynamic SQL Query. Below is the sample query, you can modify it according to your needs:
DECLARE @TSQL AS NVARCHAR(500)
DECLARE @databaseName AS NVARCHAR(20) = 'DBName'
SET @TSQL = N' INSERT INTO [' + @databaseName + '].dbo.Test([IN_300_FileID],[RecordVer]) '
SET @TSQL = @TSQL + N' SELECT FROM dbo.Test (in_300_id,record) '
SET @TSQL = @TSQL + N' INSERT INTO [' + @databaseName + '].dbo.Test1([IN_300_FileID],[RecordVer]) '
SET @TSQL = @TSQL + N' SELECT FROM dbo.Test1 (in_300_id,record) '
PRINT(@TSQL)
PRINT Result:
INSERT INTO [DBName].dbo.Test([IN_300_FileID],[RecordVer])
SELECT FROM dbo.Test (in_300_id,record)
INSERT INTO [DBName].dbo.Test1([IN_300_FileID],[RecordVer])
SELECT FROM dbo.Test1 (in_300_id,record)
Finally execute you build query with
EXEC sp_executesql @TSQL command.