ADMIN_DataType_Parse

Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

Type: Table-valued function

Parses a comma separated list of Sql Server data type specifications.

Parameters

@DataTypeStringList mandatory varchar
Comma separated list of Sql Server data type specifications, e.g. int,varchar(300),decimal(18,2)

Resultsets

Resultset: Parsed data type specifications

Table count: repeated exactly once
Row count: zero or more rows

Columns

Id mandatory int
1-based index in the input string
MaxLength optional int
Max length specified. Only for types that supports it.
Name mandatory sysname
Name of type with standard capitalization
Precision optional int
Precision for the type. Only for types that supports it.
Scale optional int
Scale for the type. Only for types that supports it.
XType mandatory int
Sql Server XType identifier for the type