sp_datatypeinfo is a system stored procedure which result in all data types that are accepted by you sql server version on their corresponding data types, precision and etc, information.
syntax for sp_datatypeinfo is:
sp_datatypeinfo <data type>
If we need data type information for all the data types in sql server syntax will be:
sp_datatypeinfo
Example:
Following picture shows the result of sp_datatypeinfo
syntax for sp_datatypeinfo is:
sp_datatypeinfo <data type>
If we need data type information for all the data types in sql server syntax will be:
sp_datatypeinfo
Example:
Following picture shows the result of sp_datatypeinfo
