Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Modifying User-defined Type Variable and Parameter Values

You can modify variables and parameters of a user-defined type in a SET statement or in the SELECT list of a SELECT statement. In either case, you modify values either by setting an individual property of the user-defined type value, or by invoking a state-modifying method on the instance of the type. To do this, you must have EXECUTE permission on the type.

This example sets a value for a user-defined type point by modifying the value of the type's property X.

DECLARE @p Point
SET @p.X = @p.X + 1.1

To modify a user-defined type variable or parameter value

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft