更新时间:2023-01-22 11:36:10
使用 SELECT ... INTO ...
,具有完全限定的表名 database.schema.object_name
,如下所示:
Use SELECT ... INTO ...
with a fully qualified table names database.schema.object_name
, like this:
USE DatabaseName;
SELECT *
FROM DatabaseName.schemaname.Tablename
INSERT INTO AnotherDatabase.schemaname.AnotherTablename;
然后您可以使用ADO.net或其他API从C#执行此查询。
Then you can use ADO.net or other API to execute this query from C#.