Sqlserver 常用sql汇总

--[临时表]

drop table #temp;

SELEct bid INTO #temp FROM sign.Dign WHERE ClienTindenNo='***';

delete FROM [check].Dxamdne WHERE bid IN (SELECT * FROM #temp);

delete FROM business.Dufiness WHERE id IN (SELECT * FROM #temp);

--[ ]


@H_674_5@