在test表插入一条数据时,test1表里该类型编号更新为流水号
create trigger updateData
on test
for insert --test表中数据新建时触发
as
UPDATE test1 set bh = ('TEST-' + (SELECT right('0000'+ cast(
(SELECT COUNT(id) FROM test1 WHERE type = '种类')
as
在test表插入一条数据时,test1表里该类型编号更新为流水号
create trigger updateData
on test
for insert --test表中数据新建时触发
as
UPDATE test1 set bh = ('TEST-' + (SELECT right('0000'+ cast(
(SELECT COUNT(id) FROM test1 WHERE type = '种类')
as