STSrid (geography Data Type)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
STSrid is an integer representing the spatial reference identifier (SRID) of the instance.
Syntax
.STSrid
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Return Types
SQL Server type: int
CLR type: SqlInt32
Remarks
This property can be modified.
Examples
The first example creates a geography
instance with the SRID value 4326 (WGS84) and uses STSrid
to confirm the SRID.
DECLARE @g geography;
SET @g = geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326);
SELECT @g.STSrid;
The second example uses STSrid
to change the SRID value of the instance to 4267 (NAD27) and then confirms the modified SRID value.
SET @g.STSrid = 4267;
SELECT @g.STSrid;
See Also
OGC Methods on Geography Instances
Spatial Reference Identifiers (SRIDs)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru