sql 2008
if not exists(
select top 1 * from actor where actor_id = '3')
begin
insert into actor values('3','ED','CHASE','2006-02-15 12:34:33')
end
sqlite
insert or ignore into actor
values(3,'ED','CHASE','2006-02-15 12:34:33');
sql 2008
if not exists(
select top 1 * from actor where actor_id = '3')
begin
insert into actor values('3','ED','CHASE','2006-02-15 12:34:33')
end
sqlite
insert or ignore into actor
values(3,'ED','CHASE','2006-02-15 12:34:33');