this should do it:

IF OBJECT_ID('tempdb..#test') IS NOT NULL

DROP TABLE #test

GO

CREATE TABLE #test (ID INT IDENTITY, colC INT ) ;

INSERT INTO #test...