SQL server 如何创建一个触发器能够实现默认值的功能
--设置表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
有帮助麻烦点下【采纳该答案】，谢谢~~
--设置表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
有帮助麻烦点下【采纳该答案】，谢谢~~