Editing: New Spatial Features in the SQL Azure Q2 2011 Service Release

Title

<h1 style="margin: 24pt 0in 0pt;">&nbsp; <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/3581.SQL-Azure-Logo.png"><img alt="" width="510" height="141" style="border-width: 0px; border-style: solid; width: 481px; height: 137px;" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x0/__key/communityserver-wikis-components-files/00-00-00-00-05/3581.SQL-Azure-Logo.png" /></a></h1>
<h1 style="margin: 24pt 0in 0pt;"><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="_Toc294611765"></a><a name="_Toc293471642"></a><a name="_Toc293329719"></a><a name="_Toc276538040"></a><a name="_Toc300146694"></a><a name="_Toc294694186">New Spatial Features in the SQL Azure Q2 2011 Service Release</a> </h1>
 
&nbsp;This post has been superseded by the newer TechNet Wiki post: <a href="http://social.technet.microsoft.com/wiki/contents/articles/updated-spatial-features-in-the-sql-azure-q4-2011-service-release.aspx">Updated Spatial Features in SQL Azure Q4 2011 Service Release</a>
SQL Azure Technical Article
Writer: Ed Katibah (Microsoft) 
Technical Reviewers: Milan Stojic (Microsoft) and Bob Beauchemin (SQLskills)
Published: October 25, 2011
Applies to: SQL Azure Q2 2011 Service Release
Summary: This release of SQL Azure introduces the updated spatial data platform created in SQL Server Code Name &ldquo;Denali&rdquo;. The SQL Server Code Name &ldquo;Denali&rdquo; spatial features are expected to be released in SQL Azure in increments, beginning with this service release. This paper documents the status of the new spatial features.
Copyright
This is a preliminary document and may be changed substantially prior to final commercial release of the software described herein.
The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.
This white paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED, OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in, or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation. 
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property. 
Unless otherwise noted, the example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious, and no association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. 
&copy; October 2011 Microsoft Corporation. All rights reserved.
Microsoft, SQL Azure, and SQL Server are trademarks of the Microsoft group of companies.
All other trademarks are property of their respective owners.
<h1 style="margin: 24pt 0in 0pt;"><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a><a name="New_Spatial_Features_in_the_SQL_Azure_Q2_2011_Service_Release"></a>New Spatial Features in the SQL Azure Q2 2011 Service Release</h1>
The Microsoft SQL Azure Q2 2011 Service Release (SR) is significant in that it represents the initial step towards providing a common base and feature set between the SQL Azure service and the upcoming release of <a href="http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx" target="_blank">SQL Server Code Name &ldquo;Denali&rdquo;</a>, now known officially as SQL Server 2012. SQL Server Code Name &ldquo;Denali&rdquo; (currently available as Community Technology Preview 3) introduces a number of new spatial features. The SQL Azure Q2 2011 SR exposes a subset of the new &ldquo;Denali&rdquo; spatial features and is the subject of this note. A white paper covering all of the new spatial features in SQL Server &ldquo;Denali&rdquo; is available <a href="http://sqlcat.com/sqlcat/b/whitepapers/archive/2011/08/08/new-spatial-features-in-sql-server-code-named-denali-community-technology-preview-3.aspx">SQLCAT.com</a>. You may also view this document from the <a href="http://social.technet.microsoft.com/wiki/contents/articles/4136.aspx">Microsoft TechNet Wiki</a>. You can use these references to explore the new spatial features presented in this document in more detail.
You can verify that your SQL Azure instance is the Q2 2011 Service Release by checking the version in SQL Server Management Studio:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
SELECT @@version 
--Returns: Microsoft SQL Azure (RTM) - 11.0.1467.26 
If your SQL Azure instance has a major version of 11, you are using the Q2 2011 SR.
Spatial features surfaced in SQL Server Code-Name &ldquo;Denali&rdquo; come in two varieties: 
<ol>
 <li style="color: #333333;">Features that are compatible with the previous version of SQL Server (SQL Server 2008 and SQL Server 2008 R2), which are designated by a value of 100 as the minimum database compatibility level. </li>
 <li style="color: #333333;">Features that are dependent on the new enhancements to the spatial data platform presented in SQL Server Code-Name &ldquo;Denali&rdquo;, which are designated by a value of 110 as the minimum database compatibility level.</li>
</ol>
In this service release, only those spatial features with a minimum database compatibility level of 100 are made available. Spatial features with a 110 designation are scheduled to make their appearance in a future SQL Azure release.
Table 1 lists the new spatial methods released in the SQL Azure Q2 2011 SR. Additional spatial methods that are expected to be made available in a future SQL Azure release are also included.
<table style="border: currentcolor; border-collapse: collapse;" border="1" cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #a6a6a6; padding: 0in 5.4pt; border: 1pt solid windowtext; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 Geography Type
 </td>
 <td valign="top" style="background: #a6a6a6; border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 Geometry Type
 </td>
 <td valign="top" style="background: #a6a6a6; border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 Minimum DB Compat Level
 </td>
 <td valign="top" style="background: #a6a6a6; border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 SQL Azure Q2SR Compatibility
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d9d9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 442.9pt; height: 0.2in; white-space: nowrap;" colspan="4">
 OGC Methods 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STContains()
 </td>
 <td valign="top" style="background: white; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 Already supported in SQL Azure 
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STConvexHull()
 </td>
 <td valign="top" style="background: white; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 Already supported in SQL Azure 
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STCurveN()
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STCurveN()
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 110
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 No1
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STCurveToLine()
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STCurveToLine()
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 110
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 No1
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STIsValid()
 </td>
 <td valign="top" style="background: white; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 Already supported in SQL Azure 
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STNumCurves()
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STNumCurves()
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 110
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 No1
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STOverlaps()
 </td>
 <td valign="top" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap; background-color: transparent;">
 Already supported in SQL Azure 
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 STWithin()
 </td>
 <td valign="top" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap; background-color: transparent;">
 Already supported in SQL Azure 
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d9d9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 442.9pt; height: 0.2in; white-space: nowrap;" colspan="4">
 Extended Methods 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 AsBinaryZM()
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 AsBinaryZM()
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes2
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 BufferWithCurves()
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 BufferWithCurves()
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 110
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 No1
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 CurveToLineWithTolerance()
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 CurveToLineWithTolerance()
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 110
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 No1
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 HasM
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 HasM
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 HasZ
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 HasZ
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 IsValidDetailed()
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 IsValidDetailed()
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes3 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 MakeValid()4.1
 </td>
 <td valign="top" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap; background-color: transparent;">
 Already supported in SQL Azure 
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes4 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 MinDbCompatibilityLevel()4.2
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 MinDbCompatibilityLevel()4.2
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes4 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 ReorientObject()4.3 
 </td>
 <td valign="top" style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap; background-color: transparent;">
 Not applicable 
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes4 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 ShortestLineTo()
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 ShortestLineTo()
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 Yes 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d9d9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 442.9pt; height: 0.2in; white-space: nowrap;" colspan="4">
 Aggregates (Extended Static Methods) 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 CollectionAggregate()
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 CollectionAggregate()
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #ff5050; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 No5
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 ConvexHullAggregate()
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 ConvexHullAggregate()
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: red; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 No5
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 EnvelopeAggregate()
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 EnvelopeAggregate()
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: #ff5050; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 No5
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 UnionAggregate()
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 139.4pt; height: 0.2in; white-space: nowrap;">
 UnionAggregate()
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 73.7pt; height: 0.2in;">
 100
 </td>
 <td valign="top" style="background: red; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 90.4pt; height: 0.2in;">
 No5
 </td>
 </tr>
 </tbody>
</table>
Table 1. Spatial methods introduced in SQL Server Code-Name &ldquo;Denali&rdquo;. Methods that make their debut in this release of SQL Azure are shown in green. Methods that are staged for presentation in a future release of SQL Azure are shown in tan/orange color. Methods with red in the SQL Azure Q2SR Support column were intended to be available but are not operational in this release.
Notes:
1Microsoft plans to support these methods in a future SQL Azure update.
2The OGC WKB constructor methods - STGeomCollFromWKB(), STGeomFromWKB(), STLineFromWKB(), STPointFromWKB(), and STPolyFromWKB() - have been updated to accept Z and M from Well-known Binary input, including Well-known Binary created by the new AsBinaryZM method.
3Microsoft plans to expose the full utility of this method for the Geography type when the remainder of the Denali spatial features are released in a future SQL Azure update. This method is fully functional in this release of SQL Azure for the Geometry type.
4Although these methods execute, their full utility is not expected to be exposed until the remainder of the Denali spatial features are released in a future SQL Azure update.
<blockquote style="margin-right: 0px;" dir="ltr">
4.1In this release of SQL Azure, invalid objects are not allowed in the Geography type. Consequently, the MakeValid() method, while present and operational for the Geography type, cannot do anything more than operate over an already valid object &ndash; effectively a no-op.
</blockquote> <blockquote style="margin-right: 0px;" dir="ltr">
4.2In this release of SQL Azure, all spatial methods are restricted to minimum database compatibility level 100. Hence, the MinDbCompatibilityLevel() method always returns 100.
</blockquote> <blockquote style="margin-right: 0px;" dir="ltr">
4.3In this release of SQL Azure, Geography polygons must occupy less than a logical hemisphere in extent. This is the same restriction under which Geography polygons operate in SQL Server 2008 and SQL Server 2008 R2. If the ReorientObject() method is applied to a Geography polygon (or multipolygon) in this release of SQL Azure, it returns NULL, because the only other option would be to return an invalid object.
</blockquote>
5Spatial aggregates are exposed in SQL Azure Q2SR but fail to execute properly due to an internal permissions issue.&nbsp;Spatial aggregates are expected to work as designed in a future SQL Azure release. Here is the error message returned when a spatial aggregate is executed:
<blockquote style="margin-right: 0px;" dir="ltr">
A severe error occurred on the current command.&nbsp; The results, if any, should be discarded. 
</blockquote>
Because no results are returned, there is no reason for concern with the error.
Additional spatial features from SQL Server Code-Name &ldquo;Denali&rdquo; make their debut in SQL Azure Q2 2011 SR. These new spatial features are presented in Table 2. Table 2 also lists several spatial features that were supposed to be present in this release but were not included.
<table width="594" style="border: currentcolor; width: 594px; height: 537px; border-collapse: collapse;" border="1" cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #a6a6a6; padding: 0in 5.4pt; border: 1pt solid windowtext; width: 2.45in; height: 0.2in; white-space: nowrap;">
 Geography Type
 </td>
 <td valign="top" style="background: #a6a6a6; border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0in 5.4pt; width: 171pt; height: 0.2in; white-space: nowrap;">
 Geometry Type
 </td>
 <td valign="top" style="background: #a6a6a6; border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0in 5.4pt; width: 62.7pt; height: 0.2in;">
 Minimum DB Compat
 Level
 </td>
 <td valign="top" style="background: #a6a6a6; border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt; height: 0.2in;">
 SQL Azure Q2SR Support
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #d9d9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 468.9pt; height: 0.2in; white-space: nowrap;" colspan="4">
 Type Class 
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in; height: 0.2in; white-space: nowrap;">
 FullGlobe
 </td>
 <td valign="top" style="background: white; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 171pt; height: 0.2in; white-space: nowrap;">
 <a name="OLE_LINK1"></a><a name="OLE_LINK2"></a>Not applicable 
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 62.7pt; height: 0.2in;">
 110
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt; height: 0.2in;">
 No1
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in; height: 0.2in; white-space: nowrap;">
 CircularString
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 171pt; height: 0.2in; white-space: nowrap;">
 CircularString
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 62.7pt; height: 0.2in;">
 110
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt; height: 0.2in;">
 No1
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in; height: 0.2in; white-space: nowrap;">
 CompoundCurve
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 171pt; height: 0.2in; white-space: nowrap;">
 CompoundCurve
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 62.7pt; height: 0.2in;">
 110
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt; height: 0.2in;">
 No1
 </td>
 </tr>
 <tr style="height: 0.2in;">
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in; height: 0.2in; white-space: nowrap;">
 CurvePolygon
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 171pt; height: 0.2in; white-space: nowrap;">
 CurvePolygon
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 62.7pt; height: 0.2in;">
 110
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt; height: 0.2in;">
 No1
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #d9d9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 468.9pt;" colspan="4">
 Spatial Indexes
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 Auto Grid spatial index
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 &nbsp;Auto Grid spatial index
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 110
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No1
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 SPATIAL_WINDOW_MAX_CELLS hint
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 &nbsp;SPATIAL_WINDOW_MAX_CELLS hint
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 110
 </td>
 <td valign="top" style="background: #fbd4b4; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No1
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 Compression for spatial indexes
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 Compression for spatial indexes
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 110
 </td>
 <td valign="top" style="background: #fde9d9; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No1
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 Nearest Neighbor query plan
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 &nbsp; Nearest Neighbor query plan
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 Yes
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #d9d9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 468.9pt;" colspan="4">
 Create Table DDL
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 Persisted computed spatial columns
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 &nbsp; Persisted computed spatial columns
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 Yes
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #d9d9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 468.9pt;" colspan="4">
 Spatial Reference System
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 New SRID for Unit Sphere: 104001
 </td>
 <td valign="top" style="background: white; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 &nbsp;Not applicable 
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 Yes
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 sys.spatial_reference_systems view
 </td>
 <td valign="top" style="background: white; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 &nbsp;Not applicable 
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: #ff5050; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No2
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #d9d9d9; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 468.9pt;" colspan="4">
 Stored Procedures 
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 sp_help_spatial_geography_histogram
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 sp_help_spatial_geography_histogram
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: red; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No2
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 sp_help_spatial_geometry_histogram
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 sp_help_spatial_geometry_histogram
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: #ff5050; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No2
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 sp_help_spatial_geography_index
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 sp_help_spatial_geography_index
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: red; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No2
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 sp_help_spatial_geometry_index
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 sp_help_spatial_geometry_index
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: #ff5050; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No2
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 sp_help_spatial_geography_index_xml 
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 sp_help_spatial_geography_index_xml 
 </td>
 <td valign="top" style="background: #d6e3bc; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: red; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No2
 </td>
 </tr>
 <tr>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0in 5.4pt; width: 2.45in;">
 sp_help_spatial_geometry_index_xml 
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 171pt;">
 sp_help_spatial_geometry_index_xml 
 </td>
 <td valign="top" style="background: #eaf1dd; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in; width: 62.7pt;">
 &nbsp; 100
 </td>
 <td valign="top" style="background: #ff5050; border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0in 5.4pt; width: 58.8pt;">
 No2
 </td>
 </tr>
 </tbody>
</table>
Table 2. New and existing spatial features and their status in the SQL Azure Q2 SR 2011 release. Features that make their debut in this release of SQL Azure are shown in green. Features that are staged for presentation in a future release of SQL Azure are shown in tan/orange color. Features with red in the SQL Azure Q2SR Support column were intended to be available but are not present in this release.
Notes:
1These features are expected to be supported in a future SQL Azure update.
2These features are supposed to be available in Q2 2011 SR but have been inadvertently excluded. These features are expected to be available in an upcoming SQL Azure release.

Comment

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?