SQL server 如何创建一个触发器能够实现默认值的功能

Question

Answer 1

--设置表a的sex默认值，如果未传递
create trigger dfvalueASex on a for insert
as
declare @id int,@sex nvarchar(10)

select @id=编号,@sex=sex from inserted
if @sex is null update a set sex='男' where 编号=@id

有帮助麻烦点下【采纳该答案】，谢谢~~