use common select * from company_detail UPDATE CITY_MASTER SET STATENAME = T1 DELETE FROM COMMON.DBO.CITY_MASTER INSERT INTO COMMON.DBO.CITY_MASTER SELECT * FROM T21N001.DBO.CITY_MASTER
use common select * from company_detail UPDATE CITY_MASTER SET STATENAME = T1 DELETE FROM COMMON.DBO.CITY_MASTER INSERT INTO COMMON.DBO.CITY_MASTER SELECT * FROM T21N001.DBO.CITY_MASTER