create table testtable(
product_no int not null,
product_name varchar(30) not null,
price money null,
expire_date date null,
expire_time time(7) null)
;

create trigger testtrigger on testtable
aftter insert,update
as
price=1
;
go

insert into testtable(poduct_no,product_name) values(1,'my product')
;