geometric datatypes

Hi,
Is there any equivalent in SQL Server for Oracle's datatype 'SDO_GEOMETRY'
Smitha

No, there is no built-in data type for storing spatial data. In SQL Server 2005, you can create your own CLR user-defined type and use it. In addition, there are other ways to do deal with spatial data. See the links below for more details. They contain whitepaper, sample from SQL Server 2005 CD etc.

http://msdn.microsoft.com/sql/learning/prog/clr/default.aspx

http://msdn.microsoft.com/sql/learning/prog/clr/default.aspx?pull=/library/en-us/dnsql90/html/tblvalfuncsql.asp

http://msdn2.microsoft.com/en-us/library/ms345264(SQL.90).aspx