I'm playing around with doing some basic sql server spatial queries on arcsde feature classes (in ssms) and have had some success working with polygons. I'm having trouble when I start querying points. I'd like to do a basic point in polygon query using STIntersects or STWithin. When I select the point layer I want to use I get a message saying "cannot call methods on int" (STWithin). When I look at the feature class in catalog, it tells me the shape field type is "geometry." When I look at it in ssms, it shows the field type as "int." I try to cast the field as geometry in my query but I get a message saying explicit conversion from int to sys.geometry is not allowed. I'm curious if anyone has insight on the int vs geometry datatype between ssms and arcgis and how I can handle the int type for a point feature class?
