how to insert data with Select statement in sql server

in this sql database we will learn that how we can use a select statement to insert data in a database table using sql server.

INSERT INTO @MyTable
SELECT OrderID, CustomerID
FROM Northwind.dbo.Orders
WHERE OrderID BETWEEN 10240 AND 10250