CollectionAggregate (geography Data Type)
Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Creates a GeometryCollection instance from a set of geography objects.
Applies to: SQL Server (SQL Server 2012 through current version), Azure SQL Database.
Throws a FormatException when there are input values that are not valid. See STIsValid (geography Data Type)
Method returns null when the input is empty or the input has different SRIDs. See Spatial Reference Identifiers (SRIDs)
Method ignores null inputs.
Method returns null if all inputted values are null.