欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

insert into select语句【可以复制Geometry字段】

程序员文章站 2023-10-12 14:09:21
insert into select语句【可以复制geometry字段】   sql server自带的导入导出功能可以导普通的属性表:   &nb...

insert into select语句【可以复制geometry字段】

 

sql server自带的导入导出功能可以导普通的属性表:

 

insert into select语句【可以复制Geometry字段】

 

        但是,如果你要复制的表中存在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')