Skip to content

Latest commit

 

History

History
54 lines (41 loc) · 1.46 KB

sty-geometry-data-type.md

File metadata and controls

54 lines (41 loc) · 1.46 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
STY (geometry Data Type)
STY (geometry Data Type)
MladjoA
mlandzic
08/03/2017
sql
t-sql
reference
STY_TSQL
STY (geometry Data Type)
STY (geometry Data Type)
TSQL
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

STY (geometry Data Type)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]

The Y-coordinate property of a Point instance.

Syntax

  
.STY  

Return Types

[!INCLUDEssNoVersion] type: float

CLR type: SqlDouble

Remarks

The value of this property will be null if the geometry instance is a point. This property is read-only.

Examples

The following example creates a Point instance and uses STY to retrieve the Y-coordinate of the instance.

DECLARE @g geometry;  
SET @g = geometry::STGeomFromText('POINT(3 8)', 0);  
SELECT @g.STY;  

See Also

STX (geometry Data Type)
STSrid (geometry Data Type)
OGC Methods on Geometry Instances