select top 5 *
into #MyTable
from sys.objects

select top 5 *
into #MyTable
from sys.objects

SELECT  object_id,
        CAST(name AS NVARCHAR(500)) AS name
INTO    #TempTable
FROM    sys.tables;

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL
DROP TABLE #TempTable

CREATE TABLE #TempTable (
	[ID] INT IDENTITY(1,1) NOT NULL,
	[Col1] INT NULL,
	[Col2] NVARCHAR(50) NULL,
	PRIMARY KEY (ID))

INSERT INTO #TempTable
SELECT 
	 Col1
	,Col2
FROM 
	dbo.TableName
WHERE
	1 = 1

[PK__#TempTable__3214EC27582F7143]

SELECT ProductID, CategoryID
INTO #TempTable
FROM dbo.Products

ALTER TABLE dbo.Products ADD PRIMARY KEY(ProductID)

DECLARE 
    @strCreateIndex NVARCHAR(1000)
   ,@IndexUniqueID NVARCHAR(50)

SET @IndexUniqueID = N'IX__#TempTable__'+REPLACE(CAST(NEWID() AS NVARCHAR(50)),'-','')
SET @strCreateIndex = 
N'CREATE NONCLUSTERED INDEX [' + @IndexUniqueID + '] ON [#TempTable] ([ProductID])'

EXEC sp_executesql @strCreateIndex