USE tempdb;
GO


CREATE TABLE #tempFoo (id int IDENTITY(1, 1) NOT NULL, valore int)

INSERT INTO #tempFoo ( valore ) VALUES (50)

SELECT * INTO #temp2 FROM #tempFoo TF

INSERT INTO #temp2 (id, valore) VALUES(5, 7)

/* 
Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table '#temp2______________________________________________________________________________________________________________000000192975' when IDENTITY_INSERT is set to OFF.

*/