STEquals (geometry Data Type)
Returns 1 if a geometry instance represents the same point set as another geometry instance. Returns 0 if it does not.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
The following example creates two geometry instances with STGeomFromText() that are equal but not trivially equal, and uses STEquals() to test their equality.
DECLARE @g geometry DECLARE @h geometry; SET @g = geometry::STGeomFromText('LINESTRING(0 2, 2 0, 4 2)', 0); SET @h = geometry::STGeomFromText('MULTILINESTRING((4 2, 2 0), (0 2, 2 0))', 0); SELECT @g.STEquals(@h);