However, they can be resolved if you embed the INSERT statements above in an SQL stored procedure with a little extra logic.
但是,如果将上述insert语句嵌入到一个包含一点额外逻辑的SQL存储过程中,就可以解决这个问题。
These columns are simply hitching a ride along the INSERT operation and are accessible to the SELECT above.
这些列只是通过INSERT操作搭载的,并且上面的SELECT可以访问这些列。
So in the example above, the NOT NULL constraint would get violated, and the INSERT statement would error out.
因此,在上面的示例中,会违反 NOT NULL 约束,INSERT 语句会出错。
应用推荐