300求解?sql server的事务问题!
下面的Sql语句执行的时候存在主键冲突,SQL Server也提示出现错误,但是为什么第一条还是被成功添加,而没有回滚
BEGIN TRAN T1
insert into TDayReport (SubjectKindID,AccoutDate) Values('1111','2002-09-09')
insert into TDayReport (SubjectKindID,AccoutDate) Values('1111','2002-09-09')
COMMIT TRAN T1