create trigger tr_insert on customer
for insert
as
if @@rowcount=0 return
update a set
rz_no=isnull(nullif((select max(rz_no) from customer),0),10000)
+(select count(*) from inserted where serial_no<=i.serial_no)
from customer a,inserted i
where a.serial_no=i.serial_no
仅供参考:
create trigger customer_insert on customer
for insert
as
if @@rowcount=0 return
update a
set rz_no=(select max(rz_no) from customer)+1
from customer a,inserted i
where a.serial_no=i.serial_no
Create Trigger [Update_rz_no] On customer
FOR INSERT
AS
Update A Set rz_no =1000+serial_no from customer A Inner Join Inserted B On A.serial_no=B.serial_no
create trigger tr_insert on customer
for insert
as
if @@rowcount=0 return
update a set
rz_no=10000
+(select max(rz_no) from customer)
+(select count(*) from inserted where serial_no<=i.serial_no)
from customer a,inserted i
where a.serial_no=i.serial_no
create trigger tr_insert on customer
for insert
as
if @@rowcount=0 return
update a set rz_no=10000+i.serial_no
from customer a,inserted i
where a.serial_no=i.serial_no