what what you got does

WhatYouGot.sql

IF OBJECT_ID(N'dbo.WhatYouGot', N'P') IS NOT NULL DROP PROCEDURE dbo.WhatYouGot;
GO
CREATE PROCEDURE dbo.WhatYouGot 
AS
BEGIN
    IF OBJECT_ID(N'tempdb.dbo.#temp', N'U') IS NOT NULL DROP TABLE #temp;
    CREATE TABLE #temp (
        id tinyint NOT NULL DEFAULT 1,
        details varchar(50) NOT NULL DEFAULT 'A head full of stupid ideas :)'
    );
    INSERT INTO #temp DEFAULT VALUES;
    SELECT id, details FROM #temp
END;
GO