jjzjj

GetUpdateCommand

全部标签

c# - SQL Server : ADO.Net GetUpdateCommand ok with PK,在添加另一个聚集唯一索引后失败

我有这样一个带有非聚集主键的表:CREATETABLE[dbo].[StudentGrade]([EnrollmentID][int]IDENTITY(1,1)NOTNULL,[CourseID][nvarchar](10)NOTNULL,[StudentID][int]NOTNULL,[Grade][decimal](3,2)NOTNULL,CONSTRAINT[PK_StudentGrade]PRIMARYKEYNONCLUSTERED([EnrollmentID]ASC))选择语句是:selectEnrollmentID,GradefromStudentGradeGetUpdat