SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-SQL » tempdb (RSS)

Browse by Tags

  • Dropping all temp tables

    In SQL Forum one of the posters asked a question about dropping all the temporary tables There are many ways to do this One of the ways to to run the following code declare @sql varchar ( 8000 ) set @sql = '' select @sql = @sql + ' drop table ' + name from tempdb .. sysobjects where xtype...
    Posted to Madhivanan (Weblog) by Madhivanan on Fri, Sep 18 2009
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems