2020.12.14
某一表A有3857的點位X與Y,要依據這兩個欄位填入geomentry型態的欄位ge:
表大概長這樣| ID | SiteX | SiteY | ge |
| ---- | ---- | ---- | ---- |
| 1 | 305622|2770506| Null|
| 2 | 303170|2773306| Null|
| 3 | 304554|2770850| Null|Update [TableA] Set ge =(SELECT geometry::Point(SiteX,SiteY,3857))執行| ID | SiteX | SiteY | ge |
| ---- | ---- | ---- | ---- |
| 1 | 305622|2770506| 0x110F0000010C...|
| 2 | 303170|2773306| 0x110F0000010C...|
| 3 | 304554|2770850| 0x110F0000010C...|