CREATE TABLE [StuFeeItem](
[StuFeeItemID]   COUNTER PRIMARY KEY  ,
[FeeItemID] Int   NULL ,
[BillItemID] Int   NULL ,
[StudentID] Int   NULL ,
[StudentName] VarChar (50)  NULL ,
[StartDate] DateTime   NULL ,
[EndDate] DateTime   NULL ,
[Amount] Int   NULL DEFAULT 0,
[ProgressAmount] Int   NULL DEFAULT 0,
[DateAndTime] DateTime   NULL ,
[Remark] VarChar (255)  NULL ,
[PostSchoolID] Int   NULL ,
[PostSchoolName] VarChar (50)  NULL ,
[TrueName] VarChar (50)  NULL ,
[UserID] Int   NULL ,
[InsertTime] DateTime   NULL ,
[LastBillItemID] Int   NULL ,
[NextPrice] Decimal (18,2)  NULL DEFAULT 0)
GO

Update DBInfo set DateAndTime='2016-04-28'
GO









