title: Modify MSSQL Statement for Webpage
body: <p>I've created a simple database for my website and it has a content management system wherein the admin can add items, which will eventually be stored in the database. But I've noticed a problem, whenever i'm testing out adding new items to my website, The id column continues to increment after deleting and adding a new item again. Lets say I have 8 fixed items on my database that has the 1-8 id respectively. I will now create the 9th item which will give me the id 9, but when i delete it and create a new item, the id number will be 10 so and so forth. What i want to happen is for the id to stay in number 9.</p>
  
  <p>Here is an image of my data overview:</p>
  
  <p><a href="https://i.stack.imgur.com/HAFS9.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HAFS9.jpg" alt="enter image description here"></a></p>
  
  <p>As you can see, my 9th item has an id of 22, which is not the result that we want.</p>
  
  <p>And here is my SQL Statement:</p>
  
  <pre><code>        /****** Object:  Table [dbo].[guitarItem]    Script Date: 21/10/2016    15:20:18 ******/
     SET ANSI_NULLS ON
     GO
     SET QUOTED_IDENTIFIER ON
     GO
     SET ANSI_PADDING ON
     GO
     CREATE TABLE [dbo].[guitarItem](
        [id] [int] IDENTITY(1,1) NOT NULL,
        [type] [varchar](50) NOT NULL,
        [model] [varchar](50) NOT NULL,
        [price] [float] NOT NULL,
        [image1] [varchar](255) NULL,
        [image2] [varchar](255) NULL,
     PRIMARY KEY CLUSTERED 
     (
      [id] ASC
     )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,     ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
      ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
      GO
     SET ANSI_PADDING OFF
      GO
     SET IDENTITY_INSERT [dbo].[guitarItem] ON
      INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2]) VALUES (1, N'Ibanez', N'ARZ307', 9000.00 , N'../Images/Guitar Brands/Ibanez Guitars/ibanezARZ307.jpg', N'../Images/Guitar Brands/Ibanez Guitars/ibanezARZ307StandingPosition.png')
      INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2]) VALUES (2, N'Ibanez', N'DT420TCR', 11000.00, N'../Images/Guitar Brands/Ibanez Guitars/ibanezDTR420TCR.jpg', N'../Images/Guitar Brands/Ibanez Guitars/ibanezDTR420TCRStandingPosition.png')
      INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2])    VALUES (3, N'Ibanez', N'JBM100', 18000.00, N'../Images/Guitar Brands/Ibanez Guitars/ibanezJBM100.jpg', N'../Images/Guitar Brands/Ibanez Brands/ibanezJBM100StandingPosition.png')
     INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1],   [image2]) VALUES (4, N'Ibanez', N'M8M', 13000.00, N'../Images/Guitar   Brands/Ibanez Guitars/ibanezM8M.png', N'../Images/Guitar Brands/Ibanez   Guitars/ibanezM8MStandingPosition.png')
    INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2]) VALUES (5, N'Ibanez', N'RGAIX7FM', 15000.00, N'../Images/Guitar Brands/Ibanez Guitars/ibanezRGAIX7FM.jpg', N'../Images/Guitar Brands/Ibanez Guitars/ibanezRGAIX7FMStandingPosition.png')
      INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2]) VALUES (6, N'Ibanez', N'JEM77P', 30000.00, N'../Images/Guitar Brands/Ibanez Guitars/ibanezJEM77P.jpg', N'../Images/Guitar Brands/Ibanez   Guitars/ibanezJEM77PStandingPosition.png')
     INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2])    VALUES (7, N'Ibanez', N'AR325', 8000.00, N'../Images/Guitar Brands/Ibanez   Guitars/ibanezAR325.jpg', N'../Images/Guitar Brands/Ibanez  Guitars/ibanezAR325StandingPosition.png')
      INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2])     VALUES (8, N'Ibanez', N'PGM3', 36000.00, N'../Images/Guitar Brands/Ibanez    Guitars/ibanezPGM3.jpg', N'../Images/Guitar Brands/Ibanez   Guitars/ibanezPGM3StandingPosition.png')
  
  
   SET IDENTITY_INSERT [dbo].[guitarItem] OFF
  </code></pre>