SQL Server空间数据合并

 

DECLARE @g geometry;  
DECLARE @h geometry;  
DECLARE @res geometry;


select  @g = shape from Ageo_CityRiver where OBJECTID =5054  ;  
select  @h = shape from Ageo_CityRiver where OBJECTID =6272  ;
--SET @h = geography::STGeomFromText('POLYGON((-122.351 47.656, -122.341 47.656, -122.341 47.661, -122.351 47.661, -122.351 47.656))', 4326);  
--select @g,@h
set @res = @g.STUnion(@h); 
--select  @res