Viewing 15 posts - 526 through 540 (of 581 total)
OK - but the transaction will aplly only to one connection - the second conn. won't have a transaction. The obvious thing is to issue the SELECT statement on the...
July 1, 2003 at 8:02 am
OK - here is a tip which Microsoft wouldn't approve of. If you enable updates top system tables, then update the sysobjects entries for the system tables you want to...
July 1, 2003 at 6:18 am
Could this be anything to do with implicit transactions? Maybe SQL 7 and 8 behave differently in this respect....
July 1, 2003 at 2:48 am
Certainly sounds like you have you transaction isolation level set to repeatable read or serializable, and a transaction isn't being closed - so that the 'select' statement is holding its...
July 1, 2003 at 2:45 am
I can think of two possible strategies for a start:
the first is to use SQL Agent as an out-of-process server. Either set up a standard job beforehand (any parameters needed...
June 27, 2003 at 3:06 am
Here's one without a temp table, but it does use multiple outer theta (inequality) joins...I'm sure SQL server will find some way of making the 4 joins to [child] a...
June 26, 2003 at 9:49 am
quote:
According to the ANSI rules (as I understand them) a WHERE clause will be applied after the ON clauses have been...
June 26, 2003 at 9:38 am
jpipes -
Spaghetti Junction is in Birmingham, UK.
It's not as impressive as I remember it - but it's a bit of a major landmark in the MidWest of England...
http://www.bplphoto.co.uk/40mb/TN200Pages/Sep2000/AerialIII.htm
...
June 26, 2003 at 7:30 am
quote:
He argues that FKs cause timeouts/lockouts, but you can avoid this with triggers. Ergo, we shouldn't use FKs and should instead build...
June 25, 2003 at 9:51 am
DALEK,
All this stuff about cascade operations is off-topic in any case, but surely the point of the site is to give info you couldn't find just by searching MSDN. For...
June 25, 2003 at 9:35 am
quote:
Obviously, for this to work, I need to be able to implemement a meaningful hierarchy.eg if the base product is a CAR,...
June 25, 2003 at 8:01 am
Need a bit more info: when you say a single-row recordset, do you mean one row per record in the main (parent, 'one') table?
June 25, 2003 at 7:47 am
DALEK:
quote:
I'm not sure what you are saying about SQL 7:quote:
...if you want...
June 25, 2003 at 7:27 am
DALEC,
when are you going to post the rest of msdn?
June 25, 2003 at 7:22 am
Frank,
the idea is to have a trigger on the table which gets the new values from the table, and generates a stored proc which will take an input param identifying...
June 25, 2003 at 4:52 am
Viewing 15 posts - 526 through 540 (of 581 total)