--用触发器实现:
create trigger tr_tbname on tbname
for insert,update,delete
as
declare @fld1 varchar(100),@fld2 varchar(100)
if exists(select 1 from inserted where (fld1 is null) and (fld2 is null))
begin
RAISERROR ('fld1和fld2不能都为空值', 16, 1)
ROLLBACK TRANSACTION
end
go