SQL Trigger to Auto-Calculate Coordinate Values

Discussion created by boyle.matt on May 5, 2014
Latest reply on Sep 6, 2016 by rfairhur24
Does anyone know if it's possible to create a SQL trigger which would auto-calculate coordinate values for a feature class?

Example: For a point feature class, when a point is added or updated, the fields 'XCoordinate' and 'YCoordinate' would be auto-updated.

If this is possible, would it also be possible to calculate the coordinate values based on another coordinate system from what is used for the feature class, like WGS84 for longitude and latitude?

Example Environment:
DBMS: SQL Server 2008 R2
Geometry: SQL Geometry

Thanks in advance!