title: Violation of PRIMARY KEY constraint 'PK_Address'. etc...what am I doing wrong?
body: <p>Evening all. I am fairly new to <code>SQL</code> but have been doing quite a bit of fooling around. I am following a guide I found online to learn <code>SQL</code> in 21 days and I am having a bit of trouble figuring out what the error I am receiving is causing.</p>
  
  <p>I am trying to <code>INSERT</code> data into an existing table. The Primary Key for this table is <code>AddressID</code>. The data I am trying to enter is in the code below:</p>
  
  <pre><code>INSERT INTO [dbo].[Address]
         (AddressID,Street,City,State,ZipCode)
  VALUES
         (1,'2400 Broadway','New York','NY',11201),
         (2,'320 21st Street','Atlanta','GA',303),
         (3,'439 Skyline Blvd','Seattle','WA',98101),
         (4,'56 Park Avenue','Dallas','TX',75201);
  GO
  </code></pre>
  
  <p>I keep getting this error:</p>
  
  <blockquote>
    <p>Msg 2627, Level 14, State 1, Line 2 Violation of PRIMARY KEY
    constraint 'PK_Address'. Cannot insert duplicate key in object
    'dbo.Address'. The duplicate key value is (1).</p>
  </blockquote>
  
  <p>I have tried just about everything I can think of but I am unable to get my table updated. My column names at under the <code>INSERT INTO</code> portion are correct and my VALUES are also correct. I did find that I can use a single <code>INSERT</code> statement to get my data in the table. Originally I was using 4 separate statements. </p>
  
  <p>What am I doing wrong? </p>