Spatially Enabling an existing Table – which has Eastings and Northing fields UK National Grid

The following TSQL will spatially enable a SQL Server Table called T1RainbowTable when it has two Fields called East and North with UK National Grid References.

UPDATE T1RainbowTable SET Coordinates=geometry::Point([East],[North],27700)