Dave (5/8/2009)

---

I saw it with Linda, a girl I was dating. When we got to the box office, the ticket seller says, "I only have two together in the...

Jamie Julius (5/8/2009)

---

Paul White (5/8/2009)

---

Jamie Julius (5/7/2009)

---

It seems to me that the proposed SQL would be considered an implicit transaction. It would be run under the default isolation mode of...

Does this mean creating a view using the OPENROWSET function didn't work? It is how I got around not being able to use NEWID() in a function, I put...

Stepping back a moment, dealing with difficult users - the flip side (yes, my post dealing with us (me)).

The best way to "defeat" us is with information. The more...

Bob Hovious (5/8/2009)

---

Are you real sure about that Paul?

Did you try it? ...

Paul,

The problem we are having is that the OP is apparently dismissing everything without considering it in context. Yes, I have tested your devils advocate position and if you...

I'll accept the devils advocate position. But, can you make it fail when the optimistic concurrency features are not in use.

At this point, we actually don't know what transaction...

UBD -- User Brain Damage ...

noeld (5/8/2009)

---

Julius,

Coding this way ( with exists ... ) is NOT needed at all.

Set up a primary key and if there is a collision handle the error accordingly.

Leave locking...

Florian Reischl (5/8/2009)

---

The (first)...

Well, nothing wrong with a Masters by course work, that was my MA as well. Trust me, though, there was plenty of research work involved outside of the classes....

This:

begin transaction

select @rows = count(*) from dbo.SomeTable where SomeID = @SomeID;

if @rows = 0

insert into dbo.SomeTable values (@SomeID)

commit transaction

WILL NOT PREVENT two sessions from entering the...

Roy, can you post the exact error messages you are getting please.

Roy Ernest (5/8/2009)

---

Not all Indians are Mor**s like him with a MSA degree (I know MSc but not MSA) ...heheheh Me, I am an Indian with just one Bachelors degree...

I'd have to do some searching, might be in that thread he started when he mentioned he wanted to get his PhD, that the M.C.A. is a Master in Computer...