Is Sql-Server 2005 Object Oriented DBMS

Greetings,
I would like to konw if Sqlserver 2005 supports Geographic Information
System (GIS) data, i.e., supports spatial data, like Oracle?
MTIA,
Grawshagrawsha2000@.yahoo.com wrote:
> Greetings,
> I would like to konw if Sqlserver 2005 supports Geographic Information
> System (GIS) data, i.e., supports spatial data, like Oracle?
>
> MTIA,
> Grawsha
SQL Server doesn't have specific features designed for GIS but it does
support user-defined datatypes and CLR (.NET) code in the database. You
can build "complex" types (points and vectors maybe) from .NET classes.
That may cover some of the features you have in mind.
As for OODBMS, it would help if you could be more specific. "OODBMS" is
commonly used as a marketing category or an imprecise term for any of
various different features and techniques. If you are looking for
encapsulation, inheritence and subclassing then you can achieve that
through .NET code either inside or outside the database server. If you
need an object store then you can also serialize .NET objects to a SQL
Server database.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||>> I would like to konw if Sqlserver 2005 supports Geographic Information
Searching MSDN bought up the following, not sure if helps:
http://msdn.microsoft.com/library/e...lValFuncSQL.asp
Anith