“创建目标表后架构更改"如何?发生错误? [英] How does a "Schema changed after the target table was created" error occur?

问题描述

我的 Web 应用程序尝试在 MSSQL 2005 数据库上执行 SELECT INTO 时遇到此错误.我真的有两个问题:

I hit this error while my web application was trying to execute a SELECT INTO on a MSSQL 2005 database. I really have two questions:

1. 这个错误是什么意思，这是如何发生的?
2. 有没有办法通过不同的编码方式来防止这些错误?

推荐答案

除了明显的，有人在代码执行时更改了表，这可能是与 SQL 中创建的临时表的命名冲突.可能有两个具有不同架构的临时表，但它们具有相同的名称.

Besides the obvious, that somebody changed the table while the code was executing, it could be a naming conflict with temp tables created in the SQL. It could be that there are two temp tables with different schemas, but they have the same name.

这篇关于“创建目标表后架构更改"如何?发生错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！