insert into select语句【可以复制Geometry字段】
程序员文章站
2023-10-12 14:09:21
insert into select语句【可以复制geometry字段】
sql server自带的导入导出功能可以导普通的属性表:
&nb...
insert into select语句【可以复制geometry字段】
sql server自带的导入导出功能可以导普通的属性表:
但是,如果你要复制的表中存在geometry字段,如果用sql server自带的导入导出表的功能将无法导入带geometry字段的表。可以用insert into select语句将一个表中的数据复制到另一表中:
两个表在同一中:
insert into mapping_geodata_boundary_code(code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id, is_thematicmap, supportfile_code, boundary_all) select code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id, is_thematicmap, supportfile_code, boundary_all from mapping_geodata_boundary
两个表在不同数据库中( openquery):
insert mapping_geodata_boundary (code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id, is_thematicmap) select code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id, is_thematicmap from openquery([10.10.1.31],'select code, name, description, type, parent_code, boundary, center_point, boundary_hole, boundary_hole_id, is_thematicmap from epro30.dbo.mapping_geodata_boundary')
推荐阅读
-
SELECT INTO 和 INSERT INTO SELECT 两种表复制语句简单介绍
-
select into 和 insert into select 两种表复制语句
-
select into 和 insert into select 两种表复制语句
-
insert into select语句【可以复制Geometry字段】
-
Oracle 中insert into与select into两种表复制语句比较
-
[MSSQL]SELECT INTO 和 INSERT INTO SELECT 两种表复制语句
-
select into 和 insert into select 全表复制sql语句
-
insert into select语句【可以复制Geometry字段】
-
SELECT INTO 和 INSERT INTO SELECT 两种表复制语句详解(SQL数据库和Oracle数据库的区别)
-
select into 和 insert into select 全表复制sql语句