You running a 5 digit lottery?

Seriously, though, just because I'm curious everytime I see such a requirement... what is the business logic...

I guess the way I'd do this is to send the inserts to one file and the deletes to another instead of having a process generate individual inserts/deletes as a...

Kory is spot on... and, (just a reminder)... all of the objects on the Oracle side must be in upper case.

I've found that our DBA's don't (have to) do much in the area of performance tuning code, only do cursory reviews of code, don't do much when it comes to...

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'...