Select into

SELECT name INTO [dbo].T FROM sysobjects
SELECT * FROM T
DROP TABLE [dbo].T