需要实现:
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