Tag Info

Hot answers tagged

4

You could extract the coordiantes and round these values: Select ROUND(SP_GEOMETRY.STX, 0) As X, ROUND(SP_GEOMETRY.STY, 0) As Y From dbo.MY_TABLE; And you can extend this so that the result is returned as a POINT: Select 'POINT(' + Cast(ROUND(SP_GEOMETRY.STX, 0) As VarChar) + ' ' + Cast(ROUND(SP_GEOMETRY.STY, 0) As VarChar) ...


2

MS SQL server Create new table or add new column. Use STGeomFromWKB to convert WKB to Geometry , then in FME do following. Add "MS SQL spatial reader" , point it to correct table ( You can do this with SQLExecute too , that eliminates need for table containing geometry type and you can just use something like SELECT STGeomFRomWKB(wkb) as geom , id from xxx ...


1

That should work without problems, double check if the parameters that you are passing to the IPropertySet object are right. Are you writing the "serverinstance" property properly? that's the most common problem. IPropertySet propertySet = new PropertySetClass(); propertySet.SetProperty("dbclient", "SQLServer"); ...



Only top voted, non community-wiki answers of a minimum length are eligible