Click the "Home" tab on the ribbon. Click the "Insert" arrow button in the Cells group to open the list of options. Click "Insert Table Columns to the Left." The columns to the right will shift.

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.

Form your initial insertion query, such as "INSERT INTO your_table (column1,column2) VALUES ('1','a');" Alter the query by adding a rule for what to do if a duplicate key is found, such as "INSERT ...