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?