mssql mysql oracle 临时表demo
1、mssql 临时表
[code="java"]
drop table #temp;
select bid into #temp FROM sign.sign WHERE no='3503221';
delete from student WHERE bid IN (SELECT * FROM #temp);
delete from score WHERE bid IN (SELECT...
原创
2017-03-14 17:57:22 ·
136 阅读 ·
0 评论