alter trigger tri3 on stu3
after insert,update,delete
as
declare @intCountColumn int,
@intColumn int,
@tmp varchar(16)
--inserted
select @intCountColumn=count(ordinal_position)
from Information_Schema.Columns
where Table_name='stu3'
--select Columns_Updated() 'COLUMNS UPDATED'
set @intColumn=1
while @intColumn<=@intCountColumn
begin
if Columns_updated() & @intColumn=@intColumn
set @tmp = Col_Name(Object_ID('stu3'),@intColumn)
INSERT DEMO (ACTIONID,ACTIONTYPE,TABLENAME,COLUMNNAME,NEWVALUE) VALUES (1,'I','stu',Col_Name(Object_ID('stu3'),@intColumn), '0')
print 'Column (' + Cast(@intColumn as varchar)+')'+Col_Name(Object_ID('stu3'),@intColumn)+' has been changed'
set @intColumn = @intColumn+1
end
insert stu3 (name) values( 'defu')
select * from demo