Export (0) Print
Expand All
Expand Minimize

STSrid (geometry Data Type)

STSrid is an integer representing the spatial reference identifier of the instance.

This property can be modified.


STSrid

SQL Server type: int

CLR type: SqlInt32

The first example creates a geometry instance with the SRID value 13 and uses STSrid to confirm the SRID.

DECLARE @g geometry;
SET @g = geometry::STGeomFromText('POLYGON((0 0, 3 0, 3 3, 0 3, 0 0))', 13);
SELECT @g.STSrid;

The second example uses STSrid to change the SRID value of the instance to 23 and then confirms the modified SRID value.

SET @g.STSrid = 23;
SELECT @g.STSrid;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft