做个嵌套好了 先判断表1 如果不存在就接着判断是否在表2里面 也不存在就插入到表3 否则就跳出就可以了
if NOT EXISTS (SELECT 1 FROM tablename1 WHERE FirstID = @id)And NOT EXISTS (SELECT 1 FROM tablename2 WHERE SecondName = @name)begin---end
