摘要:
create table num_tb(d datetime,id int)insert num_tb select '2004-01-01',1create table tb(id varchar(20),name varchar(10))create clustered index idx_clu_tb on tb(id)gocreate trigger tri_tb on tbINSTEAD OF INSERTasbeginset nocount ondeclare @i int,@id varchar(20),@j intselect @i=count(*) from 阅读全文