I am very new to MS SQL 2008. I got a task to select a polygon from the polygon layer by giving the X-Y coordinates. I already got the script for PostgreSQL for the same thing, but I need it for MS SQL 2008. the code in PostgreSQL is:
SELECT * FROM "Kar_bbmp_198" WHERE ST_Within ((ST_GeomFromText('POINT(773824 1442012)',32643)), the_geom) = TRUE;`
Can anybody help me from this?