需要实现:
if not exists(select * from ErrorConfig where Type='RetryWaitSeconds') begin insert into ErrorConfig(Type,Value1) values('RetryWaitSeconds','3') end
只能用:
insert into ErrorConfig(Type,Value1) select 'RetryWaitSeconds','3' where not exists(select * from ErrorConfig where Type='RetryWaitSeconds')因为 sqlite 中不支持SP