Lab Sql

I tried to serialize a DataTable object to xml. The DataTable has a column with type 'geography… Read more Datatable With Sqlgeography Column Can't Be Serialized To Xml Correctly With Loss Of Lat,long And Other Elements

I have a table like this in SQL Server 2008: serv_type coords ------------------------ shop … Read more Sql Server 2008 Geography - Spatial Result - Color Based On Another Column Value

In sql-server-2012 I want to generate view with all points from geometry type. How can I do this? V… Read more Generate View With X And Y From Geometry Type

I'm trying to retrieve geography data from my SQl Server 2012 DB with: new SqlDataAdapter('… Read more One Of The Identified Items Was In An Invalid Format - Microsoft.sqlserver.type

I'm using geography data type for calculating shortest distance. CREATE TABLE Landmark ( … Read more Sql Server Geography Latitude Longitude Error

I have been tracking down a bug in my code, and I've found that it's because the Microsoft … Read more Why Is There A Difference In SqlGeography STDistance?