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
SELECT @p
GO

To modify a user-defined type variable or parameter value

• SET @local\_variable (Transact-SQL)
• SELECT Clause (Transact-SQL)

See Also

Concepts

Working with CLR User-defined Types

Other Resources

CLR User-Defined Types

Help and Information

Getting SQL Server 2005 Assistance