In SQL Server. With:: The difference between _mssql

An instance of SQL Server is given below, and the following SQL runs under 2008 environments:

DECLARE @g Geography;
SET @g = Geography::P arse (' LINESTRING (-122.360 47.656,-122.343 47.656) ');

SELECT @g;
SELECT @g.tostring ();

The result set is:

0xe610000001148716d9cef7d34740d7a3703d0a975ec08716d9cef7d34740cba145b6f3955ec0

LINESTRING (-122.36 47.656,-122.343 47.656)

Geography is a new type of support geographic information that is added to SQL Server 2008 and is not described here because it is beyond the scope of this article.

We only look inside the geography::P arse Method and the @g.tostring () method, you can see that the parse method is called through geography type Support, equivalent to the Class.staticmethod form in C #, ToString ( ) is called through the instance of G.

If you want to reprint, please specify this article original from CSDN tjvictor column