CREATE TABLE [dbo].[CHECKINOUT]( [USERID] [int] NOT NULL, [CHECKTIME] [datetime] NOT NULL, [CHECKTYPE] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [VERIFYCODE] [int] NULL, [SENSORID] [nvarchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [WorkCode] [int] NULL, [sn] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [aaaaaCHECKINOUT_PK] PRIMARY KEY NONCLUSTERED ( [USERID] ASC, [CHECKTIME] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)