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

Материал из SQL эксперт
Перейти к: навигация, поиск

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>