Tuesday, February 12, 2013

SQL Server Check --- IF Exists


IF EXISTS(SELECT * FROM tempdb.dbo.sysobjects WHERE ID = OBJECT_ID(N'tempdb..#temp_det_for_mst'))
BEGIN
DROP TABLE #temp_det_for_mst
END

No comments: