ALTER TABLE [dbo].[Attend] ALTER COLUMN LessonDegreeID int not null
GO

ALTER TABLE [dbo].[Attend] ALTER COLUMN StuClassID int not null
GO

ALTER TABLE [dbo].[Attend] DROP CONSTRAINT [PK_Attend]
GO

ALTER TABLE [dbo].[Attend] ADD  CONSTRAINT [PK_Attend] PRIMARY KEY CLUSTERED 
(
	[LessonDegreeID] ASC,
	[StuClassID] ASC
)
GO

Update DBInfo set DateAndTime='2013-10-20'
GO














