Peristiwa
31 Mac, 11 PTG - 2 Apr, 11 PTG
Acara pembelajaran SQL, Fabric dan Power BI terbesar. 31 Mac - 2 April. Gunakan kod FABINSIDER untuk menjimatkan $400.
Daftar hari iniPelayar ini tidak lagi disokong.
Naik taraf kepada Microsoft Edge untuk memanfaatkan ciri, kemas kini keselamatan dan sokongan teknikal yang terkini.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
SQL database in Microsoft Fabric
Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries/regions, roads, or lakes.
SQL Server supports two spatial data types: the geometry data type and the geography data type.
The geometry type represents data in a Euclidean (flat) coordinate system.
The geography type represents data in a round-earth coordinate system.
Both data types are implemented as .NET common language runtime (CLR) data types in SQL Server.
In SQL database in Microsoft Fabric, geography and geometry data types are supported but cannot be mirrored to the Fabric OneLake.
Create, Construct, and Query geometry Instances
Describes the methods that you can use with instances of the geometry data type.
Create, Construct, and Query geography Instances
Describes the methods that you can use with instances of the geography data type.
Query Spatial Data for Nearest Neighbor
Describes the common query pattern that is used to find the closest spatial objects to a specific spatial object.
Create, Modify, and Drop Spatial Indexes
Provides information about creating, altering, and dropping a spatial index.
SQL Server spatial tools is a Microsoft sponsored open-source collection of tools for use with the spatial types in SQL Server. This project provides a set of reusable functions which applications can make use of. These functions may include data conversion routines, new transformations, aggregates, etc. See Microsoft/SQLServerSpatialTools in GitHub for more details.
Peristiwa
31 Mac, 11 PTG - 2 Apr, 11 PTG
Acara pembelajaran SQL, Fabric dan Power BI terbesar. 31 Mac - 2 April. Gunakan kod FABINSIDER untuk menjimatkan $400.
Daftar hari iniLatihan
Laluan pembelajaran
Write advanced Transact-SQL queries - Training
Write advanced Transact-SQL queries
Pensijilan
Microsoft Certified: Azure Data Engineer Associate - Certifications
Demonstrate understanding of common data engineering tasks to implement and manage data engineering workloads on Microsoft Azure, using a number of Azure services.
Dokumentasi
Query spatial data for nearest neighbor - SQL Server
Query spatial data for nearest neighbor, used to find the closest spatial objects to a specific spatial object.
GeometryCollection - SQL Server
GeometryCollection is a collection of zero or more geometry or geography instances in SQL Database Engine spatial data.
Create, construct, and query geometry instances - SQL Server
Geometry instances represent data in a Euclidean (flat) coordinate system. Learn how to create, construct, and query geometry data in SQL Database Engine spatial data.