That's almost exactly correct... it would, indeed, be a multi-row insert using a loop in the GUI.  Or, you could store each answer in an answer staging table if you...

Stephen Falken: Except, that I never could get Joshua to learn the most important lesson.

David Lightman: What's that?

Stephen Falken: Futility. That there's a time when...

I gotta ask... what will this be used for?

For batch inserts you Call GetNextID with a @count parameter *once*

Yep, I'm aware of that, but then you...

Nope... gave credit where credit was due... I got lazy and said "heck, they probably don't have the right kind of index, anyway, so why bring it up?"  You reminded...

Nope... if you don't have an index, using the function or not has no effect on speed... both are the same for the most part.  Only difference is if you...

That too, will work, but as Chris Morris pointed out, any time you do a calculation/function on a column in the WHERE clause, you will decrease performance (A LOT!!) if a...

I found this in Books Online...

When the IDENTITY property is used with CREATE TABLE, Microsoft® SQL Server™ uses the NOT FOR REPLICATION option of CREATE TABLE to override the...

Um... I gotta ask... why wouldn't 0.3333 represent all of the numbers from 0.3332(5) to 0.3333(4) in the TR model?

Well, maybe an Index Scan... but you're (almost) exactly correct... the OR in this case will certainly allow an Index SEEK to occur if the correct index is available.  

I...

No, David... JacekO did it just right... try it and see...

--===== Declare and populate a test table

DECLARE @test-2 TABLE (RowNum INT IDENTITY(1,1), SomeString VARCHAR(10))

 INSERT INTO @test-2 (SomeString)

 SELECT 'A'...

Like I said earlier to your core question... "Yes". 

It's just a bad idea to shrink files that are destined to grow again because of file fragmentation.  You must first...

No problem, Noel... it's easy to see how I might have been taken because I was pretty adamant about the whole IDENTITY thing.

So,...

Eamon,

I was a bit out of line... I should have asked why you need to do this so we can come up with the best solution for your circumstance. 

So,...

So... someone wanna ask the OP what's up?