ADMIN_DataType_Parse

 Show all Hide all

Deprecated.

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

Type: Table-valued function
Area of use: General use

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

Repeat mode: 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