-- duplicate post: having problems submitting this end! --

I take the view that it is safest, on balance, to agree with people who are...

Hey Flo,

I hope you know that I would have offered to read it too - but I have had very little time this week to check the threads here.

I'm sure...

Jack,

The three of us are agreeing - though the casual observer might be hard pressed to spot it :laugh:

Paul

Darth,

That was my attempt to highlight the difference between the posted examples, and the only actually 'dangerous' one I can think of (which I posted).

As you say, it is just...

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 "Read committed". I don't...

RBarryYoung,

How does that go with:

Select @i = object_id from sys.objects

...?

Paul

(a confirmed SELECT-ite, mostly)

I am?

I am!

Were you about to post something similar? Because I claim prior art!

See http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/t-sql-variables-multiple-value-assignment.aspx

My comment is at the very bottom...

John,

When assigning multiple variables from constants, SELECT is significantly quicker than separate SET statements.

Just adding that for completeness.

Paul

Bob,

It works fine now. The primary key is safe! 😀

Paul

Bob,

No worries at all - don't give it a second thought.

[my pointless code deleted at this point, lol]

@noeld: thanks! It amused me.

Paul

I agree entirely with your comments there.

Though it is said:

"Let (s)he who is without pork chop, throw the first pork chop"

...or...

You need to SET TRANSACTION ISOLATION LEVEL SNAPSHOT to use that level. READ...

Bob Hovious (5/8/2009)

---

Are you real sure about that Paul?

Did you try it?

Would somebody else try it? Because I just created a new...

I know the conversation has moved on a bit, but:

I just want to say that while it may not seem like it sometimes, I do try hard to be tolerant...