IF(条件) BEGIN PRINT '成功' COMMIT END ELSE BEGIN PRINT '失败' ROLLBACK END
raiserror但这个提示好像也只有在查询分析器中看到如果是自己的程序里面,好像看不到
create trigger View_Update on TempStu_View instead of insert as begin declare @SNO char(10) select @SNO=substring(sNo,1,2) from inserted if @SNO='99' begin begin insert into TempStudents(sNo,sName) select sNo,sName from inserted print '插入学生信息成功!' end begin insert into TempAchies(sNo,suName,suAchieve) select sNo,suName,suAchieve from inserted print '插入成绩成功' end end else begin rollback transaction raiserror('插入的信息只能为99级学号的学生信息!',16,1) end end下面的语句失败: insert into TempStu_View values('9708','刘刚','计算机英语',96)
BEGIN
PRINT '成功'
COMMIT
END
ELSE
BEGIN
PRINT '失败'
ROLLBACK
END
on TempStu_View
instead of insert
as
begin
declare @SNO char(10)
select @SNO=substring(sNo,1,2)
from inserted
if @SNO='99'
begin
begin
insert into TempStudents(sNo,sName)
select sNo,sName
from inserted
print '插入学生信息成功!'
end
begin
insert into TempAchies(sNo,suName,suAchieve)
select sNo,suName,suAchieve
from inserted
print '插入成绩成功'
end
end
else
begin
rollback transaction
raiserror('插入的信息只能为99级学号的学生信息!',16,1)
end
end下面的语句失败:
insert into TempStu_View
values('9708','刘刚','计算机英语',96)