Another useful variation of the INSERT command is the "SIF" format to create a table with fields based on the source table:
SELECT Id, Name, Quantity
INTO SomeOtherTable -- Or even @SomeOtherTable
This will create a table ("SomeOtherTable") with the Id, Name, and Quantity columns from the Fruit table. You can specify a WHERE clause to limit the records you pull out (WHERE Quantity > 2). Useful for on-the-fly requirements to get a subset of records out of a larger table to manipulate or scan through.