修改字段大小: alter table CpblNews alter column title varchar(500)
触发器:当insert一条数据的时候,update这条数据 create trigger trig_notic_UI on notic for insert,update as update notic set memo=memo+'<dcboy>' where id in(select id from inserted) go
修改字段大小: alter table CpblNews alter column title varchar(500)
触发器:当insert一条数据的时候,update这条数据 create trigger trig_notic_UI on notic for insert,update as update notic set memo=memo+'<dcboy>' where id in(select id from inserted) go