And that's why it is considered best practice to include the column list of the destination table. Something like the following, but I don't know how the real structure of the table is.
INSERT INTO Products(
ProductID,
ProductName,
Price)
SELECT 1,
'Shirt',
12.99
EDIT:
You can use Object Explorer to make this task easier. Navigate to the table and use your mouse to drag the Columns folder of the table to the desired place in your code.