SIR I AM REALLY SORRY I DONT HAVE AN OPTION OF SCRIPT DATA I JUST SCRIPT MY TABLE

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ATTEND_LOG]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[ATTEND_LOG](

[EID] [int] NULL,

[date] [datetime] NULL,

[timein] [datetime] NULL,

[timeout] [datetime] NULL,

[BID] [int] NULL,

[EBID] [int] NULL,

[spendtime] [datetime] NULL,

[excessshort] [datetime] NULL,

[excess] [nvarchar](50) NULL,

[remarks] [varchar](50) NULL,

[SHIFT] [varchar](50) NULL

) ON [PRIMARY]

END