Use of user defined data type in table variable

• Vitalia

  Grasshopper

  Points: 15

  More actions

  July 8, 2003 at 7:42 am

  #82711

  Running below TSQL code

  EXEC sp_addtype N'type_udt1', N'char (6)', N'null'

  EXEC sp_addtype N'type_udt2', N'smallint', N'null'

  DECLARE @myTbl TABLE ( myId type_udt1 NOT NULL,

  OriginId type_udt2 NOT NULL)

  I got the error message:

  Server: Msg 2715, Level 16, State 7, Line 9

  Column or parameter #1: Cannot find data type type_udt1.

  Neither in BOL, nor in MSDN I see a constraint to forbid the use of user defined data type in udf.

  Need I to use system data types?

  Do you have any suggestion?

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  July 10, 2003 at 7:02 am

  #464838

  You are right. Looks like Microsoft recently updated this information in msdn online.

  Check this out

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_de-dz_66w5.asp

  which now contains,

  A user-defined data type cannot be used as a column scalar data type.