Copy table data from database to another database table in same sql server -SQL SERVER

use[test]



GO

SET IDENTITY_INSERT TBL_STATEMASTER ON

INSERT INTO TBL_STATEMASTER (id,stateid,statename,remarks,statestatus,EnteredDate,EnteredBy,UpdatedDate,UpdatedBy)
SELECT id, stateid,statename,remarks,statestatus,EnteredDate,EnteredBy,UpdatedDate,UpdatedBy
FROM ark.dbo.TBL_STATEMASTER

SET IDENTITY_INSERT TBL_STATEMASTER OFF
GO

Results

(2 row(s) affected)