T-SQL打开和关闭自增

直接看代码:

--关闭自增
SET IDENTITY_INSERT T_Class ON

--从另一个库插入数据
insert into T_Class(id,CourseID,ModelID,ClassAdviser,OpeningTime,ClassState,
flag,ClassRoomID,RatedNumber,TotalTrainingHours,TuitionFee,AverageFee,
OtherFee,ClassType,[Description],CampusID,EndTime,OperateUserID,OperateDate,
ClassCode
)
select id,CourseID,ModelID,ClassAdviser,OpeningTime,ClassState,
flag,ClassRoomID,RatedNumber,TotalTrainingHours,TuitionFee,AverageFee,
OtherFee,ClassType,[Description],CampusID,EndTime,OperateUserID,OperateDate,
ClassCode
 from 
YXSchoolV2DB_BYD.dbo.T_class
where  OperateDate<'2011-03-01' and OpeningTime>'2011-05-01'
and ClassCode not like 'xmx%' and  ClassCode not like 'qh%'
and id not in(select id from T_Class)


--打开自增
SET IDENTITY_INSERT T_Class OFF