|
Comments
|
|
its nice, it will help a lot
|
|
Maria Carmen on
1/19/2010
This video is very good and nice.
|
|
|
This video is nice to learn how to handle error in transactions.
SET XACT_ABORT is easy to use & undersand .
Thanks ...
|
|
|
This has given the better way of handling the transaction.
|
|
|
better video quality would be nice
|
|
Todd M Heflin on
1/19/2010
Great video! This command is so much easier.
|
|
|
Good series.
|
|
|
never heard of xact_abort
|
|
|
so god video, can you show how subtitute xact_abort into triggers, because i guess this sentence it's deprecated in sql 2008?. I thankful your help. my mail is karlos_arba@hotmail.com
|
|
|
nifty technique; well-presented
|
|
|
It does exactly what it says on the tin.
It is a good example on how the SET something ON or OFF is a vital part of our SQL knowledge.
|
|
|
awesome, awesome and awesome work....extremely helpful. Thanks pros.
|
|
|
Nice presentation
|
|
Marc Moshman on
1/21/2010
very cool
|
|
|
Interesting. It's one of those things that even experienced SQL developer might not know!
|
|
Mick Letofsky on
1/25/2010
Even though the XACT_ABORT command allows for transactions to automatically be rolledback, the best practice provided by SQL is the TRY..CATCH block. We have been using the TRY..CATCH blocks and throwing the errors into a logging table for quite some time. We have been able to significantly decrease the "fishing" that occurs WHEN errors happen in large applications.
|
|
|
Begin Try/ Catch block is common but this... Thank you for the new knowledge...*i'm still learning*.
|
|
|
explained in a clear cut way..
|
|
|
Great!
|
|
|
Good way to explain and good to know. Great work Andy.keep it up
|
|
|
How elegantly simple.
|
|
|
This is great for someone like me that is trying to learn. Great Video!!
|
|
|
Even better that Try/Catch blocks!
|
|
|
simple and well explained!
|
|
|
excelent!!!
|
|
|
very good
|
|
|
nice 1
|
|
|
Very useful!!
|