Viewing 15 posts - 526 through 540 (of 582 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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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....
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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
...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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,...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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?
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 25, 2003 at 7:47 am
DALEK:
quote:
I'm not sure what you are saying about SQL 7:quote:
...if you want...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 25, 2003 at 7:27 am
DALEC,
when are you going to post the rest of msdn?
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
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...
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
June 25, 2003 at 4:52 am
Viewing 15 posts - 526 through 540 (of 582 total)