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"
((ST_GeomFromText('POINT(773824 1442012)',32643)), the_geom) = TRUE;
Can anybody help me from this, thanks in advance