Hot answers tagged sql-server
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) ...
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 ...
On The Geoserver Layer Page, there is the option at the bottom of the page Reload feature type ... Bear in mind if you change any of your existing columns, any SLD may need to be changed. If it is just adding additional columns, should be no need to recreate the layer
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