SQL Server/T-SQL Tutorial/System Functions/sp addtype

execute sp_addtype id,"varchar(11)" ,"NOT NULL"

   <source lang="sql">

execute sp_addtype id ,"varchar(11)" ,"NOT NULL" GO</source>

sp_addtype creates your own specific datatypes, including how the SQL Server will handle NULL values.

   <source lang="sql">

sp_addtype typename, SQLtype[,NULLhandler] sp_addtype HireDate,datetime,"NOT NULL"</source>

User-Defined Datatypes

   <source lang="sql">

29> 30> sp_addtype ssn, "varchar(11)", "NOT NULL" 31></source>