更新时间:2023-11-23 21:28:28
Create an INSERT trigger to increment a product count.
Here is the code
create table Products ( ID int identity primary key )
GO
create table ProductCounter ( ProductCount int not null default 0 )
GO
insert ProductCounter default values
GO
create trigger trgIncrementProductCount
on Products
after insert
as
begin
update ProductCounter
set ProductCount = ProductCount + 1
end
GO
insert Products default values
insert Products default values
select * from ProductCounter
insert Products default values
insert Products default values
select * from ProductCounter