I want to store a map that is drawn using Map info software, then store it into the database, but I have not known about spatial data in sql server
I tried creating a table using geometry data type like:
use master go CREATE TABLE Districts ( DistrictId int IDENTITY (1,1), DistrictName nvarchar(20), DistrictGeo geometry); GO
but it raised an error:Column, parameter, or variable #3: Cannot find data type geometry.
As far as I know the MS sql server 2005 is also support this data type