We got tremendous response to our very first video of SQL in Sixty Seconds #001. We talked about how to convert Subquery to CTE very quickly. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips which we believe would be helpful to readers.
In today’s SQL in Sixty Seconds Rick Morelan has presented very visual reach concept of SQL Server. We all have idea how SQL Server reacts when it encounters T-SQL Error. Today Rick explains the same in quick seconds. When I personally watched this video, I suddenly felt that this is great to clear our basics. After watching this I felt confident to answer talk about SQL Server’s reaction to Error.
More on Errors:
Explanation of TRY…CATCH and ERROR Handling
Create New Log file without Server Restart
Tips from the SQL Joes 2 Pros Development Series – SQL Server Error Messages
I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.
Reference: Pinal Dave (http://blog.sqlauthority.com)