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

by

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
GO
CREATE TABLE #Results ( Company CHAR(3), StepId TINYINT, FieldId TINYINT )
GO
select company, stepid, fieldid from #Results
GO
ALTER TABLE #Results ADD foo VARCHAR(50) NULL
GO
select company, stepid, fieldid, foo from #Results
GO
IF OBJECT_ID('tempdb..#Results') IS NOT NULL DROP TABLE #Results
GO

More Related Contents:

  1. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  2. What is the best way to create and populate a numbers table?
  3. What’s the difference between a temp table and table variable in SQL Server?
  4. Sql Server string to date conversion
  5. Local and global temporary tables in SQL Server
  6. SQL Server query to find all permissions/access for all users in a database
  7. SQL Server IN vs. EXISTS Performance
  8. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  9. SQL Server add auto increment primary key to existing table
  10. PIVOT in sql 2005
  11. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  12. EF4 – The selected stored procedure returns no columns
  13. Atomic UPSERT in SQL Server 2005
  14. Do I really need to use “SET XACT_ABORT ON”?
  15. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  16. SQL Server ORDER BY date and nulls last
  17. How to remove accents and all chars a..z in sql-server?
  18. How to query values from xml nodes?
  19. How to query for Xml values and attributes from table in SQL Server?
  20. What happens to the primary key Id when it goes over the limit?
  21. How do you change the datatype of a column in SQL Server?
  22. SQL Server recursive query
  23. Milliseconds wrong when converting from XML to SQL Server datetime
  24. nvarchar(max) vs NText
  25. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  26. “Prevent saving changes that require the table to be re-created” negative effects
  27. Get row where datetime column = today
  28. Convert UTC Milliseconds to DATETIME in SQL server
  29. Full text catalog/index search for %book%
  30. @@ERROR and/or TRY – CATCH

Leave a Comment