有没有办法模拟SQL服务器错误响应/状态而不写一些降低数据库的东西？

Question

The other day on our production DB we had a few bad queries come to light that caused some blocking in our productions systems. While these queries have been fixed, there was another problem that somehow our application started displaying the message "A type 1000 server error has occurred". I'm trying to update our application to appropriately handle this, unfortunately I don't seem to be able to easily regenerate the state SQL server was in that caused this error. Is there a way to "short circuit" a request to SQL so the DB will give a response but indicate that it is in a "locked" or "unable to execute" state?

Answer 1

In SQL, you could use TRY...Catch to return whatever response you want.