Lab Sql

This is a follow up to the question Nested stored procedures containing TRY CATCH ROLLBACK pattern?… Read more Recording Sql Server Call Stack When Reporting Errors

I did not find any good error testing function for the results of an sqlQuery and that surprises me… Read more Rodbc Error Handling For Sqlquery

I don't know what can be a reason and I spent already hours on the Web trying to figure out wha… Read more Whenever Sqlerror Never Works

The following code gives an error during execution. string connectionString = 'Data Source=D:\\… Read more Error In Connection To Database

This is related to this question but slightly different, I have while loop that inserts records and… Read more How To Continue Executing Rest Of While Loop Even If An Exception Occurs In Sybase?

An exit handler is being ignored by my stored procedure. I execute the following line: CALL updateT… Read more Mysql Exit Handler Ignored

We implement the majority of our business rules in the database, using stored procs. I can never de… Read more How To Handle Db Constraint Violations In The User Interface?

Currently I have a large import process that I'm trying to wrap inside a transaction so if anyt… Read more How To Rollback A Transaction In Tsql When String Data Is Truncated?