• I agree with the comments above, but on the other hand I understood why the question's "Right" answer had to be the Identity function - I had never heard of it and it is a nice simple solution to a problem that I have encountered many times, needing to create a temp table with an Identity column explicitly instead of simply using Select Into like I usually do when I (really) need a temp table.

    The question could do with a little rewording / putting into context, but I learned something new and very interesting today 🙂

    http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.