Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Check if a temporary table exists and delete if it exists before creating a temporary table

ayi

<t>Check if a temporary table exists and delete if it exists before creating a temporary table</t>

ayi

<t>I cannot reproduce the error. 
 
Perhaps I'm not understanding the problem. 
 
The following works fine for me in SQL Server 2005, with the extra "foo" column appearing in the second select result:

IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results<br/>
GO<br/>
CREATE TABLE #Results ( Company CHAR(3), StepId TINYINT, FieldId TINYINT )<br/>
GO<br/>
select company, stepid, fieldid from #Results<br/>
GO<br/>
ALTER TABLE #Results ADD foo VARCHAR(50) NULL<br/>
GO<br/>
select company, stepid, fieldid, foo from #Results<br/>
GO<br/>
IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results<br/>
GO<br/>
<br/>
```</t>