Hi,
I have a User Defined Datatype, which I want to use to define another
data-type. I tried the obvious:
EXEC sp_addtype
@typename = UDT_OBJECT_ID,
@phystype = 'NUMERIC (5)',
@nulltype = 'NULL'
GO
EXEC sp_addtype
@typename = UDT_TRACKING_NUM,
@phystype = UDT_OBJECT_ID,
@nulltype = 'NOT NULL'
GO
but that didn't work :
Msg 15036, Level 16, State 1, Server SKINNER, Procedure sp_addtype, Line 186
The data type UDT_OBJECT_ID does not exist.
Has anyone done this before,
Thanks,
Rowland.