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.