How to import table using “INSERT” statement, in MS SQL Server?

Answer 1

insert into tablename
select * from otherdb.dbo.othertable

above statement can be used to import data from other database.
We can use OPENROWSET utility.