The INSERT error transfers control to the exit handler for that SQLSTATE code.
INSERT错误将控制转移到 SQLSTATE代码的退出处理程序。
When the INSERT statement fails with the error code specified in the DECLARE exit handler statement, control passes to the handler, and the procedure is exited.
当insert语句失败并且错误代码在DECLAREEXIThandler语句中指定,那么控制将传递到处理程序,而过程将退出。
So in the example above, the NOT NULL constraint would get violated, and the INSERT statement would error out.
因此,在上面的示例中,会违反NOT NULL约束,INSERT语句会出错。
Use TRY..CATCH construct or check the @@ERROR variable after executing a data manipulation statement (like INSERT/UPDATE/DELETE).
在执行数据操作语句(像INSERT/UPDATE/DELETE)之后,使用TRY..CATCH结构或者检查该@@ERROR变量
A common error is to inadvertently insert the cup in too much anteversion.
一个常见的失误是不经意地使臼杯过于前倾。
A common error is to inadvertently insert the cup in too much anteversion.
一个常见的失误是不经意地使臼杯过于前倾。
应用推荐