sql 是否执行sql函数判断?

Question

insert into oac_file values('',GETDATE(),'')
sql 有没有一个函数来判断 是不是执行了?
update oea_file set oea21='' where oea51 in (select oea51 from oea_file where oea51='a124820007968')
and oea10='昆山仓库' and (oea02='在库' or oea02='待收货') and (insert into oac_file values('',GETDATE(),''))
如果 insert 成功 猜 update

Answer 1

@@rowcount 看一下，是否》0，如果是再继续insert into oac_file values('',GETDATE(),'')if @@rowcount>1 update oea_file set oea21='' where oea51 in (select oea51 from oea_file where oea51='a124820007968') and oea10='昆山仓库' and (oea02='在库' or oea02='待收货') and (insert into oac_file values('',GETDATE(),''))