主题:help
create trigger grade_trigger
on sc
for insert
as
declare @ag int
select @ag=grade
from inserted
if @ag between 0 and 100
print('记录插入成功')
else
begin
print('输入错误,请重输')
rollback
end
哪位高手可否把这个触发器的每一行是什么意思给小弟翻译以一下! 谢谢
on sc
for insert
as
declare @ag int
select @ag=grade
from inserted
if @ag between 0 and 100
print('记录插入成功')
else
begin
print('输入错误,请重输')
rollback
end
哪位高手可否把这个触发器的每一行是什么意思给小弟翻译以一下! 谢谢