title: Cannot find data type time sql server 2008 r2
body: <p>I have problem error syntax with notice </p>
  
  <blockquote>
    <p>Cannot find data type time.</p>
  </blockquote>
  
  <p>this my query SQL Server 2008 R2</p>
  
  <pre><code>CREATE TABLE test
    (
       ID             INT IDENTITY(1, 1) PRIMARY KEY,
       Emp_No         VARCHAR (255),
       AC_No          VARCHAR (255),
       No             VARCHAR (255),
       NAME           VARCHAR(255),
       Auto_Assign    VARCHAR(255),
       Date           DATETIME,
       Timetable      VARCHAR(255),
       on_duty        TIME,
       off_duty       TIME,
       clock_in       TIME,
       clock_out      TIME,
       Normal         INT,
       Realtime       INT,
       Late           INT,
       Early          INT,
       Absent         VARCHAR(255),
       OT_Time        TIME,
       Work_time      TIME,
       Departmen      VARCHAR(255),
       total_telat    INT,
       sakit          VARCHAR (255),
       ijin           VARCHAR (255),
       cuti           VARCHAR (255),
       alpha          VARCHAR (255),
       dinas_luar     VARCHAR (255),
       ket_dinas_luar VARCHAR(255),
       sts_tgl_merah  VARCHAR(255),
       telat_1_30min  INT,
       lembur_status  VARCHAR(255),
       lembur_time    INT
    ); 
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/StjrZ.png" alt="enter image description here"></p>