Welcome to MSDN Blogs Sign in | Join | Help

October 2008 - Posts

Thursday, October 30, 2008 5:25 PM

SQL 2008 Spatial Samples, Part 3 of 9 - SQL Builder API

This post covers the SqlGeographyBuilder & SqlGeometryBuilder Classes & their methods. Overview of Methods to make your own Spatial Objects using the Builder API. SQL provides a Builder API that permit you to easily write your own Spatial Data
Posted by davele | 3 Comments
Wednesday, October 29, 2008 3:45 PM

SQL 2008 Spatial Sample, Part 4 of 9 - Methods for Drawing Spatial Shapes

This post covers the following methods: STDimension, STGeometryType, STNumGeometries, STGeometryN, STNumPoints, STPointN, STNumInteriorRing / NumRings, STInteriorRingN / RingN, STExteriorRing, STX / Long, STY / Lat, Z & M (measure). Note: Unless otherwise
Posted by davele | 3 Comments
Monday, October 27, 2008 1:03 PM

SQL 2008 Spatial Samples, Part 5 of 9 - Performance Improvement Methods

This post covers the following methods: Reduce, STEnvelope, EnvelopeCenter, EnvelopeAngle, STConvexHull. Note: Unless otherwise stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio (SSMS) & run. Sometimes
Posted by davele | 1 Comments
Saturday, October 25, 2008 4:40 PM

SQL 2008 Spatial Samples, Part 6 of 9 - Geometric “Set Theory” Methods

This post covers the following methods: STUnion, STIntersection, STDifference, STSymDifference, STCentroid / STEnvelopeCentre, STPointOnSurface, STBoundary. Overview of Geometric "Set Theory" Methods These Methods help to understand the relationship
Posted by davele | 1 Comments
Friday, October 24, 2008 11:53 PM

SQL 2008 Spatial Samples, Part 7 of 9 - STBuffer ... Spatial starts here.

This post covers only 2 methods: STBuffer & BufferWithTolerance . They are so handy, they deserve a post all to themselves. Note: Unless otherwise stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio
Posted by davele | 1 Comments
Friday, October 24, 2008 7:36 PM

SQL 2008 Spatial Samples, Part 8 of 9 - Conditional Methods

This post covers the following methods: STDisjoint, STIntersects , Filter,  STTouches , STWithin , STContains ,  STOverlaps , STCrosses,  STRelate, & STEquals One day these examples may find their way to Books Online. For now they can
Posted by davele | 10 Comments
Wednesday, October 22, 2008 7:27 AM

Handy sample Connection Strings

Remembering the exact syntax of a connection string is a pain. The following are links to my favourite articles on making a connection string.   Connection Strings.Com   Another great site for developers is The Code Project: ADO Connection Strings
Posted by davele | 0 Comments
Friday, October 17, 2008 10:10 AM

SQL 2008 Spatial Samples, Part 9 of 9 - Handy but Obvious Methods

This post covers the following methods: STArea, STLength, STDistance, STIsEmpty, STIsClosed, STIsSimple, STIsRing. Overview of Handy but obvious Methods The following methods are self evident. I’ve included here for the sake of completeness. You
Posted by davele | 3 Comments
 
Page view tracker