create table #a(id int,name varchar(20) default '')--改一下insert into #a (id)values(1) select * from #adrop table #a
create table Taa(id int,name varchar(20) default '0')--改一下 go create trigger dddd on Taa for insert as declare @a varchar(20) declare @id int select @id = id,@a = name from inserted if @a = '' update Taa set name = '0' where id = @id goinsert into Taa (id,name)values(1,'') select * from Taa /*id name ----------- -------------------- 1 0(所影响的行数为 1 行) */drop table Taa
select * from #adrop table #a
create table Taa(id int,name varchar(20) default '0')--改一下
go
create trigger dddd
on Taa
for insert
as
declare @a varchar(20)
declare @id int
select @id = id,@a = name from inserted
if @a = '' update Taa set name = '0' where id = @id
goinsert into Taa (id,name)values(1,'')
select * from Taa
/*id name
----------- --------------------
1 0(所影响的行数为 1 行)
*/drop table Taa