In this example, Transact-SQL will create a new table with all columns from the rows in "old_table" in which the last name starts with "Ja." ...

explicitly identify each table with a specific command. You can insert specific values into a table with an Identity column, but, to do so, you must first set the IDENTITY_INSERT value to ON.