Incorrec syntex near Lat expecting '(' or select

Question

DECLARE @g geography SET @g= geography::Point([Lat] [Long] 4326) as SAME_GEOM FROM FencePointsBAHA FB WHERE (Lat 0) AND (Long 0) and FenceIDFK=16

Kunal Patel · Answer

I have only modified your query as per your question. So what is issue now ?

mohan singh · Answer

ok its fine Kunal but now it is working as a subquery

Kunal Patel · Answer

- You doesn't apply select statement in your query. - it's look like this. DECLARE @g GEOGRAPHY SET @g = ( SELECT geography::Point([Lat] [Long] 4326) AS SAME_GEOM FROM FencePointsBAHA FB WHERE ( Lat 0 ) AND ( Long 0 ) AND FenceIDFK = 16 )

Incorrec syntex near Lat ,expecting '(' or select