SQL: transfer record from one database to another

        /* The following snippet will copy the complete record with Id = 9 from 
        [databaseName1].[tableName] to [databaseName2].[tableName]*/

        INSERT INTO databaseName1.dbo.tableName 
        SELECT * FROM databaseName2.dbo.tableName 
        WHERE tableName.Id = 9