title: Auto-generated row on Microsoft SQL Server
body: <p>I am currently working on fingerprint-based student attendance system. I am using Arduino Uno and fingerprint sensor to get student attendance record and store in SQL Server. I have a table called <code>Attendance</code> in my database which is storing student attendance records.But I have a problem with that.</p>
  
  <p>Lets say <strong>Student A</strong> is <strong>absent</strong> today, the attendance record will not be stored in table <code>Attendance</code> for Student A. Meaning that I can only show students who are <strong>present</strong> to school today, the attendance record for Student A cannot be shown to the teachers. </p>
  
  <p>Teachers can only view student attendance record after selecting the date, Student A attendance record cannot be seen by teachers cause there is no records for Student A in table <code>Attendance</code> </p>
  
  <p>So How can I solve this? Any suggestion or reference? Your help is appreciated. Thank you </p>