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);

--[ ]