更新时间:2021-07-14 23:00:56
在 SQL Server 上?并且在同一个数据库服务器上?使用三部分命名.
On SQL Server? and on the same database server? Use three part naming.
INSERT INTO bar..tblFoobar( *fieldlist* )
SELECT *fieldlist* FROM foo..tblFoobar
这只是移动数据.如果要移动表定义(以及其他属性,例如权限和索引),则必须执行其他操作.
This just moves the data. If you want to move the table definition (and other attributes such as permissions and indexes), you'll have to do something else.