What is the relation between Coordinate System and spatial Data Type ?
I creates some FCs :
1. Coordinate System : Projected, Config Keyword : Geography. Result: Failed. SQL Native Client 11.0: The multi-part identifier "SHAPE.STSrid" could not be bound"
2. Coordinate : Projected, Keyword : Geometry. Result ; Success
3. Coordinate : Geography, Keyword : Geography. Result ; Success
4. Coordinate : Geography, Keyword : Geometry. Result ; Success
What factor are causing the error ? Which spatial data type should I choose for Projected and Geography coordinate system ?
[SQL Server 2012. Arcgis 10.1]