• CREATE TABLE #MyTable(<column name> <column Type> , etc)

    INSERT #MyTable(<fields>

    exec master.dbo.xp_msver