System Functions MSSQL Tutorial

sp_addtype typename, SQLtype[,NULLhandler]
sp_addtype HireDate,datetime,"NOT NULL"