[Column name] is_nullable [Description] 1 = Parameter is nullable. (the default). 0 = Parameter is not nullable, for more efficient execution of natively-compiled stored procedures. [Data type] 
bit
i n t
s y s n a m e
t i n y i n t
s m a l l i n t
b i t
s q l _ v a r i a n t