Click here to Skip to main content
15,900,973 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL and the growing log file Pin
totig26-Aug-04 3:47
totig26-Aug-04 3:47 
GeneralRe: SQL and the growing log file Pin
Rocky Moore31-Aug-04 20:18
Rocky Moore31-Aug-04 20:18 
GeneralNested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar25-Aug-04 14:29
Sanjeev Kumar25-Aug-04 14:29 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
S Sansanwal25-Aug-04 16:33
S Sansanwal25-Aug-04 16:33 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar25-Aug-04 16:46
Sanjeev Kumar25-Aug-04 16:46 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay25-Aug-04 22:34
Colin Angus Mackay25-Aug-04 22:34 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 7:07
Sanjeev Kumar26-Aug-04 7:07 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay26-Aug-04 8:45
Colin Angus Mackay26-Aug-04 8:45 
What the book is saying, and you've already realised, is that if you start a transaction in ADO.NET you must complete it in ADO.NET. If you start a transaction in T-SQL you must complete it in T-SQL. You can of course nest transactions inside each other.

For example (in this pseudo code)
Start transaction 1
  Start transaction 2
    -- Do stuff
  End transaction 2
End transaction 1

The above is perfectly fine. Transaction 1 and 2 can both be in T-SQL, or both be in ADO.NET or Transaction 1 can be in ADO.NET with Transaction 2 being in T-SQL.

Think of it like loops, you can start a for loop and call into another method that perhaps has another for loop inside it. The for loop in the inner method must complete before the for loop in the outer method can complete. Does this make sense?

As for a published article... I am not sure about that. The text you've quoted seems perfectly reasonable to me. How competant is your boss? (Hmmm... maybe that is a bad question) How technical is your boss? Could he understand it in a way similar to the for loop analogy? If he is less technical, how about a Russian doll analogy? (The Russian dolls that are hollow and one fits inside the other, they split at the waist so you can enclose one doll around another. Pretend that the base is a start transaction, the head is the end transaction, and each size of doll is a different technology. You must obviously match the correct base with the correct head otherwise they won't fit together properly.)

Does this help?


"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!


GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 13:59
Sanjeev Kumar26-Aug-04 13:59 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay27-Aug-04 6:07
Colin Angus Mackay27-Aug-04 6:07 
GeneralParse sql query without executing Pin
tocheng00525-Aug-04 11:42
susstocheng00525-Aug-04 11:42 
GeneralRe: Parse sql query without executing Pin
S Sansanwal25-Aug-04 16:31
S Sansanwal25-Aug-04 16:31 
GeneralRe: Parse sql query without executing Pin
tocheng00526-Aug-04 12:07
susstocheng00526-Aug-04 12:07 
GeneralDataSet with GUIDs Pin
mikasa25-Aug-04 11:21
mikasa25-Aug-04 11:21 
GeneralRe: DataSet with GUIDs Pin
mikasa27-Aug-04 3:05
mikasa27-Aug-04 3:05 
GeneralDealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 10:36
david@mindplay.com25-Aug-04 10:36 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay25-Aug-04 11:13
Colin Angus Mackay25-Aug-04 11:13 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 11:28
david@mindplay.com25-Aug-04 11:28 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay25-Aug-04 12:22
Colin Angus Mackay25-Aug-04 12:22 
GeneralRe: Dealing with special characters in SQL queries Pin
mikasa25-Aug-04 11:24
mikasa25-Aug-04 11:24 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 11:51
david@mindplay.com25-Aug-04 11:51 
GeneralRe: Dealing with special characters in SQL queries Pin
david@mindplay.com25-Aug-04 12:13
david@mindplay.com25-Aug-04 12:13 
GeneralRe: Dealing with special characters in SQL queries Pin
mikasa26-Aug-04 3:38
mikasa26-Aug-04 3:38 
GeneralRe: Dealing with special characters in SQL queries Pin
Colin Angus Mackay26-Aug-04 12:01
Colin Angus Mackay26-Aug-04 12:01 
GeneralRe: Dealing with special characters in SQL queries Pin
mikasa27-Aug-04 3:05
mikasa27-Aug-04 3:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.