I seem to be having difficulty creating a spatial view in SQL Server. The format I use is basically identical to the example in the Help, but I am getting this error:
Msg 102, Level 15, State 1, Procedure spvw_TEST, Line 2
Incorrect syntax near ','.
Does anyone know why it would be complaining about a comma (it is the first comma after "vw.FieldID" below)? Here is an abbreviated version of the code I am trying to run:
CREATE VIEW spvw_TEST
AS SELECT (vw.FieldID,vw.Field1,vw.Field2,fc.Shape)
FROM vw_AllMain vw JOIN FeatsDistrib fc
ON vw.txtFeatID = fc.txtFeatID