XP for the programmer
When a TSQL script creates a temporary table, it is useful in developing mode to drop the table if it exists.
The following script does the job:
IF OBJECT_ID( N'tempdb..#MyTempTable') IS NOT NULLDROP TABLE #MyTempTable
Post a Comment
No comments:
Post a Comment