棘手的SQL与Sql Geometry字段不同

棘手的SQL与Sql Geometry字段不同

您可以强制转换为VARBINARY（MAX），然后重新强制转换。

create table tbl1 ( ID int, a int, b char(3), d geometry );create table tbl2 ( ID int, a int, b char(3), d geometry, other float );insert tbl1 (ID, a, b, d) values    (1, 2, 3, geometry::STGeomFromText('POLYGON ((0 0, 150 0, 150 150, 0 150, 0 0))', 0)),    (2, 3, 3, geometry::STGeomFromText('POLYGON ((0 0, 150 0, 150 150, 0 150, 0 0))', 0)),    (3, 4, 3, geometry::STGeomFromText('POLYGON ((0 0, 150 0, 150 150, 0 150, 0 0))', 0)),    (4, 2, 3, geometry::STGeomFromText('POLYGON ((0 0, 250 0, 150 150, 0 150, 0 0))', 0)),    (5, 2, 3, geometry::STGeomFromText('POLYGON ((0 0, 350 0, 150 150, 0 150, 0 0))', 0))insert tbl2 (ID, a, b, d) values    (6, 2, 3, geometry::STGeomFromText('POLYGON ((0 0, 150 0, 150 150, 0 150, 0 0))', 0)), -- same as tbl1.ID=1    (7, 2, 3, geometry::STGeomFromText('POLYGON ((0 0, 950 0, 150 150, 0 150, 0 0))', 0)),    (8, 2, 3, geometry::STGeomFromText('POLYGON ((0 0, 350 0, 150 150, 0 150, 0 0))', 0)); -- same as tbl1.ID=5SELECt A, B, cast(c as geometry) cFROM(    Select A,B,cast(D as varbinary(max)) c FROM tbl1    UNIOn    SELECt A,B,cast(D as varbinary(max)) FROM tbl2) X;