Geography data type error
Geography data type error
(OP)
I have a field in a table with the geography data type.
I can write to the field using a lat & long reference which gives me a value of: 0xE6100000010CF4F8BD5D7F063CC059349D9D0C2A6340
When I try to extract the lat out of that field using, I receive the error:
I thought this should work?
I can write to the field using a lat & long reference which gives me a value of: 0xE6100000010CF4F8BD5D7F063CC059349D9D0C2A6340
When I try to extract the lat out of that field using
CODE
SELECT GEOLOCATION.LONG
CODE
Could not find property or field 'long' for type 'Microsoft.SqlServer.Types.SqlGeography' in assembly 'Microsoft.SqlServer.Types'.
I thought this should work?
RE: Geography data type error
CODE
Sample from here
---- Andy
There is a great need for a sarcasm font.
RE: Geography data type error
RE: Geography data type error
CODE
I read something about case sensitivity regarding spatial data