Restrictions on the anchored data type

Review the restrictions on the use of the anchored data type before declaring variables of this type or when troubleshooting problems related to their use.

The following restrictions apply to the use of anchored data types:

Anchored data types are not supported in inline SQL functions.
Anchored data types cannot reference nicknames or columns in nicknames.
Anchored data types cannot reference typed tables, columns of typed tables, typed views, or columns of typed views.
Anchored data types cannot reference a statistical view that is associated with an expression-based index, or columns of a statistical view that is associated with an expression-based index.
Anchored data types cannot reference declared temporary tables, or columns of declared temporary tables.
Anchored data types cannot reference row definitions associated with a weakly typed cursor.
Anchored data types cannot reference objects with a code page or collation that is different from the database code page or database collation.