use pubs
go--a.create trigger insertsales
on sales
for insert
asif exists(select 1 from inserted where datediff(day,ord_date,getdate())>0)
begin
rollback tran
raiserror('定单日期不能早于当前日期',12,1)
return
end
if exists(select 1 from inserted where qty<10)
begin
rollback tran
raiserror('定单数量小于10',12,1)
return
end
go--b.create trigger updatetitles
on titles
for update
as
if exists(select 1 from inserted where advance>1500)
begin
rollback tran
raiserror('advance列不应更新为大于1500的值',12,1)
return
end
go
--c.
exec sp_helptext insertsales--d.
alter trigger updatetitles
on titles
with encryption
for update
as
if exists(select 1 from inserted where advance>1500)
begin
rollback tran
raiserror('advance列不应更新为大于1500的值',12,1)
return
end
go
go--a.create trigger insertsales
on sales
for insert
asif exists(select 1 from inserted where datediff(day,ord_date,getdate())>0)
begin
rollback tran
raiserror('定单日期不能早于当前日期',12,1)
return
end
if exists(select 1 from inserted where qty<10)
begin
rollback tran
raiserror('定单数量小于10',12,1)
return
end
go--b.create trigger updatetitles
on titles
for update
as
if exists(select 1 from inserted where advance>1500)
begin
rollback tran
raiserror('advance列不应更新为大于1500的值',12,1)
return
end
go
--c.
exec sp_helptext insertsales--d.
alter trigger updatetitles
on titles
with encryption
for update
as
if exists(select 1 from inserted where advance>1500)
begin
rollback tran
raiserror('advance列不应更新为大于1500的值',12,1)
return
end
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货