If not exists (SELECT ID FROM StuffAgitationYield where EMAgitation_ID=1 and YieldDateTime'2012-06-13 00:00:00' and TraySerial=3)
begin
end;
//if not exists，即如果不存在。就执行begin end;中间SQL。
相关文章
- 03-17SQL2008-中不想插入从复记录
2024-03-17 10:44:40
If not exists (SELECT ID FROM StuffAgitationYield where EMAgitation_ID=1 and YieldDateTime'2012-06-13 00:00:00' and TraySerial=3)
begin
end;
//if not exists，即如果不存在。就执行begin end;中间SQL。