The pubs sample database contains some user-defined datatypes.
In each of the following examples, the user-defined datatype definition explicitly defines the nullability. Quotation marks are used when a parameter contains blanks or punctuation marks. Note that these user-defined datatypes already exist in pubs, so these procedures cannot be added here.
sp_addtype id, 'varchar(11)', 'NOT NULL' sp_addtype tid, 'varchar(6)', 'NOT NULL' sp_addtype empid, 'char(9)', 'NOT NULL'
In each case, nullability has been explicitly defined. Each of these datatypes will be used multiple times throughout the sample database.