how to judge if the temptable or normal table that you created exists
just as the following scripts shows:
1.temp table
if exists (select * from sysobjects where objectproperty(object_id('TempTableName'),'istable') = 1)
2.normal table
if object_id('tablename') is null
1.temp table
if exists (select * from sysobjects where objectproperty(object_id('TempTableName'),'istable') = 1)
2.normal table
if object_id('tablename') is null