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:



Following picture shows the result of sp_datatypeinfo

This entry was posted in . Bookmark the permalink.

Leave a reply