1、其实检查可以放到程序里,不必用触发器。
2、你的触发器只能处理每次插入一条记录。
3、如果你保证每次只插入一条记录,你的触发器可以如下修改:CREATE TRIGGER pb ON [dbo].[client]
FOR INSERT AS
declare @numbeds int,
@status intselect @numbeds=numbeds,@status=status
from room,inserted
where roomrno=inserted.rno if (@numbeds=2 and @status>2 ) or @status>4
begin
rollback
print "the room is full"
endif
go
2、你的触发器只能处理每次插入一条记录。
3、如果你保证每次只插入一条记录,你的触发器可以如下修改:CREATE TRIGGER pb ON [dbo].[client]
FOR INSERT AS
declare @numbeds int,
@status intselect @numbeds=numbeds,@status=status
from room,inserted
where roomrno=inserted.rno if (@numbeds=2 and @status>2 ) or @status>4
begin
rollback
print "the room is full"
endif
go
create default kkk
as '0000'
go
sp_bindefault kkk,table1.k
和
alter table table1
add
constraint k default '0000' for k
sp_bindefault kkk,table2.k2