Select into

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

Kommentar verfassen