SQL Query to move multiple records from one Table to another in SQL Server

Refer:

1. Insert multiple rows from one table to another in SQL Server with Example

You can use this sample query ..

--CREATE TABLE AA (ID int, FNAME nvarchar(50),LNAME nvarchar(50))
--CREATE TABLE BB (ID int, FNAME nvarchar(50),LNAME nvarchar(50))

--INSERT INTO AA VALUES(1,'Sam','Richard'),(2,'Mark','Smith'),(3,'Kevin','Jones'),(4,'Steven','White'),(9,'Clara','Robinson')
--INSERT INTO BB VALUES(10,'Peter','Gellar'),(11,'Rob','William'),(12,'John','Parker'),(13,'Tai','xui'),(9,'lily','Jones')

--Select * from AA
--Select * from BB

--INSERT INTO BB (ID,Fname,Lname)
--Select ID,Fname,Lname from AA

Select * from BB

Delete from AA
--DROP TABLE AA

Output: