SQL Check Existence of Table or Temp Table

Standard Table

IF EXISTS(SELECT * FROM sysobjects WHERE name='MyTempTable' AND xtype='u')

IF object_id('tempdb..#MyTempTable') IS NOT NULL

Additional Interesting Articles

Automatically Redirect People To Different Landing Pages in PHP
Execute Files Remotely Using PSExec
Pearson Coefficient
PHP All Over Again
SQL Difference Between IS NULL and =NULL
PHP Cookie And Authentication

©2008 AndrewKimball.com