Not 100% sure on that one.... i'd run a test and see which way the wind blows....

Ugh... you got me there:). I didn't realize they had crippled it that much.

Kind of defeats the purpose of getting something to learn with I think. ...

Me too - like, yesterday:) (All right - RPG, not the dice and board,...

Cascade delete is based on the PK/FK relationships (or more specifically - the constraints). Turn them off, and you turn off everything related to them....

Actually - the ORDER by doesn't need to be in the inner query (cut and paste error on my part when copying your code). Bump it to the outer...

Lynn - try this on as a starting point:

http://msdn2.microsoft.com/en-us/library/ms156450.aspx

Haven't much played with it, but there are some specifics there on setting up the connections, and some of the links in...

Here's a trick I used when getting "used" to VS2005: use the wizards. Put a gridview down on a form, and it's going to launch into a wizard. ...

On #2: you're not allowing for the fact that T2.afield might be null (when the OUTER part might kick in), so the optimizer will "overrule" your determination of OUTER, and...

Those two queries won't return the same data. You're asking SQL for two entirely different things.

The first query is equivalent to :

select * from T1

left outer join...

Have you rebuilt all of the indexes once you ported the DB over? Make sure your statistics are current and valid.

Also - like Kenneth pointed out, the optimizer sometimes...

I'm not sure I get it. Why not CALL the stored proc from within ADO.NET? You'll get your results back and you can do whatever you wish with...

All right - I'll go with that. Jeff- you need to pick your "number". You know - so that we can say...

I have the start to one. I need to spiffy them up and I will see what I can do about posting them.

Andras Belokosztolszki (2/27/2008)

---

When you commit the outermost transaction, the transaction commits.

However, when you roll back, no matter how many begin transactions you have, the main transaction will be rolled...

Kick a man while he's down ,heh? (just kidding). It would be nice if those going over BOL would put...