title: Generate unique ID when adding a row of data to SQL Server database using Visual Basic
body: <p>I am currently writing an inventory program for my future business. I can already add, delete, update my server. </p>
  
  <p>My problem is that I want to set a unique ID like "ID-0012" or something like that when I try to add the date to my table. Currently I'm only getting ID = 1,2,3,4... </p>
  
  <p>My table consists of ID, Name, Description, Price, Date. I am currently searching for an answer through google, and I have found out that I need to code this in the SQL Server. I tried using uniqueidentifier but I am getting an error of operation type clash.</p>