作为外键暂且叫它主表吧,Delete from Main Where id=@id 则要先删除子表当中 Delete from Detail where MainId = @id 为了保证数据完整性,最好将上面的操作包含在一个事务中,如果两个语句影响的行数都大于零,则提交,否则回滚
建议在表的属性中设置级联删除,让sqlserver自己处理.自己做需要考虑事务处理
delete from exam372 where exam372.name in (select name from exam372_TEMP b ) delete from exam372 a where EXISTS (select name from exam372_TEMP b where a.name=b.name)
则要先删除子表当中 Delete from Detail where MainId = @id
为了保证数据完整性,最好将上面的操作包含在一个事务中,如果两个语句影响的行数都大于零,则提交,否则回滚
delete from exam372 a where EXISTS (select name from exam372_TEMP b where a.name=b.name)