Tuesday, September 21, 2010

checking the temp tables before deleting in SP

IF OBJECT_ID('tempdb..#TempXml') IS NOT NULL
BEGIN
DROP TABLE #TempXml
END