SQL Server throws a wobbly when one tries to declare/create the same-named temporary table more than once in the same procedure - I guess the query analyser assumes that all temp table creations ...

DROP TABLE SalesHistory; GO. CREATE ... If you want to view other types of table type definitions in your system, ... SQL Server 2008’s table parameter feature is a huge step forward in terms of ...